Referencing each 10th line of another sheet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • luftikus143
    New Member
    • Jan 2007
    • 97

    Referencing each 10th line of another sheet

    Hi,

    I am not an Excel expert; guess this question is rather simple to answer. But haven't found anything on the web.

    I have a sheet A in which some country aggregations are being done. Say, line 10, 20, 30, 40... have the country SUMs for the 9 variables in the lines above.

    How can I now have in sheet B in line 1 the results from line 10 in sheet A, in line 2 the results from line 20 etc...?

    Any simple solution to this?

    Thanks for any tipps!
Working...