Sep 15 2022 09:43 PM
Current have a spread sheet with two tabs, the first is CSV Quoting which i enter all my data (each line is a job), and then i have a template tab to which i i have standard forms - and i need to change 4 cells to reflect the line number i am working on.
So, i would like to be able to make the 93 a number i could change in a cell on the template tab.
='CSV Quoting'!I93
Currently, i need to do a find and replace to change the value in this example 93 to another number - which reflects a new line in the CSV quoting tab.
I have tried to create this cell (E5) on this page to enter the number, and when i try i get a formula error (example of the ='CSV Quoting'!&E5 or if i remove the & the value comes back as zero).
Can anyone help?
Sep 15 2022 09:49 PM
Solution@Dominic35 You need to use INDIRECT.
Try this:
=INDIRECT("'CSV Quoting'!"&E5)
where E5 need to contain a text like I93.
Sep 15 2022 09:49 PM
Solution@Dominic35 You need to use INDIRECT.
Try this:
=INDIRECT("'CSV Quoting'!"&E5)
where E5 need to contain a text like I93.