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

"Luke M" wrote:

Argh! I left out opening quotation mark.
=INDIRECT("'Tour managers Spreadsheet'!A"&(ROW()*2+6))
or
=INDIRECT("'Tour managers Spreadsheet'!A"&ROW())*2+6

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"stew" wrote:

Hi Luke

Can't seem to make any of thes work . Will not accept as a Formula

Any Thoughts

Stew

"Luke M" wrote:

=INDIRECT('Tour managers Spreadsheet'!A"&(ROW()/2*4+2)+4)
Note that your math operations at the end simplify to
=INDIRECT('Tour managers Spreadsheet'!A"&(ROW()*2+6))
However, if you want the value of cell A & ROW(), and then want to perform
math operations
=INDIRECT('Tour managers Spreadsheet'!A"&ROW())*2+6

Does this answer your question?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"stew" wrote:

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