|
address
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 |
address
=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 |
address
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 |
address
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 |
address
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 |
address
So you may want to experiment with a term like ROW()*2+6+INT((ROW()-2)/51) ?
-- David Biddulph "stew" wrote in message ... 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 |
address
Hi Luke and David
My problem is solved thanks to your attention Thanks again Stew "David Biddulph" wrote: So you may want to experiment with a term like ROW()*2+6+INT((ROW()-2)/51) ? -- David Biddulph "stew" wrote in message ... 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 |
| All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com