address

S

stew

Hi all
How do I turn
='Tour managers Spreadsheet'!A10
Into
='Tour managers Spreadsheet'! and for the cell "A"&(ROW()/2*4+2)+4

Question is how do I attach the two parts of the Formula

Thanks

Stew
 
S

stew

Hi Luke

Yes This now works . Thank you. However I have found an irregularity in the
layout in that This Formula Picks out every second Line from the "Tour
managers spread sheet " but on line 110 the next line we want is 113 and
regular every two lines after(115,117,119 etc) until 213 and then we want
216(218,220,222 etc) and onwards. In other words every 103 line the
requirement shifts!!
Can you adapt to suit?

Best

Stewart
 
D

David Biddulph

So you may want to experiment with a term like ROW()*2+6+INT((ROW()-2)/51) ?
 
Top