There's gotta be an easier way....

[DONDOU]

Ok - I have another question. Sorry.

I've got two tabs in my spreadsheet (Tab 1 and Tab 2). On tab 2, I'm attempting to copy and paste the value that's in every 11 rows of tab 1 starting with cell A18. (It's the sum of several items). So for example, I need the value in cells A18, A29, A40, etc....

I want to copy that value and paste it in A1, A2, A3, etc....on tab2.
But I don't want to copy and paste every single cell on the spreadsheet. (150 items)

Is there an easy formula I can use for this to drag down the entire column of the spreadsheet?

Thanks in advance for the help.



Don.

 

[Fluff]

How about
=INDIRECT("Sheet1!A"&((ROW(A1)-1)*11)+18)

 

[DONDOU]

For some reason, doesn't appear to be working.

 

[Fluff]

Did you change the sheet name to suit?

 

[Aladin Akyurek]

In A1 of Sheet2 enter and copy down:

=INDEX(Sheet1!$A$18:$A$109,11*(ROWS($A$1:A1)-1)+1)

 

[DONDOU]

Yes. I'm sure there's something I'm doing that's causing the error. Getting "REF! error.
In the cell G6 of sheet 2, I have =INDIRECT('SHEET1'!K18&((ROW('SHEET2'!G6)-1)*11)+18))

Sheet 2 will have the formula (and result) in consecutive rows. Sheet 1 is where I'm pulling the info from in every 11 rows.

I'm sure I'm just not explaining it correctly.

 

[DONDOU]

Aladin - That seemed to do the trick! I'm not sure what on earth it means...or what I'm doing....but it worked! Thank you!!!!

 

[Aladin Akyurek]

Aladin - That seemed to do the trick! I'm not sure what on earth it means...or what I'm doing....but it worked! Thank you!!!!

You are welcome. Try Evaluate Formula or F9 technique to see how it works.