=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