Hi there,
I'm looking to find a formula that will take every 16th row's cell value, and use it in consecutive rows in a different worksheet.
The attached illustrates what I mean.
I'm looking to build a table in sheet1 to show the year end values, based on the info in sheet2.
Basically cell B2 in sheet 1 should equal the value of cell n28 of sheet 2, then cell B3 in sheet 1 should equal the value of cell N44 of sheet 2.
Is there a way I can do this easily? I'm really looking for the rationale behind this so I can apply it to any other case like this.
Many thanks.
Bookmarks