Hi all,
I have a large formula which currently looks into another workbook, part of which is as follows: [Project_Record_List_05.02.2016.xlsx]Customer Handling'!$B$15), the 'Customer Handling' is of course the title of the tab the formula is referencing in to but is also written in cell C2 in the destination file. Currently this formula is written in 50 sheets and updated weekly therefore I have to go into each sheet, change the date, eg. where you can see... '05.02.2016' is for this week so it can look at last weeks data, I change this on the first tab, then select all tabs, copy the formula across then proceed into each sheet and change each tab title (Because of course I changed the date in the first tab now all of the others look at the data from that tab), in this example 'Customer Handling' to the tab I am writing the formula for.
What I was hoping to achieve is that I could use cell C2 as a reference point for that formula, so it will look in the same location etc but will look for the name in C2?
Is this possible?
Many thanks,
Harvey
I have a large formula which currently looks into another workbook, part of which is as follows: [Project_Record_List_05.02.2016.xlsx]Customer Handling'!$B$15), the 'Customer Handling' is of course the title of the tab the formula is referencing in to but is also written in cell C2 in the destination file. Currently this formula is written in 50 sheets and updated weekly therefore I have to go into each sheet, change the date, eg. where you can see... '05.02.2016' is for this week so it can look at last weeks data, I change this on the first tab, then select all tabs, copy the formula across then proceed into each sheet and change each tab title (Because of course I changed the date in the first tab now all of the others look at the data from that tab), in this example 'Customer Handling' to the tab I am writing the formula for.
What I was hoping to achieve is that I could use cell C2 as a reference point for that formula, so it will look in the same location etc but will look for the name in C2?
Is this possible?
Many thanks,
Harvey
