I have 1 excel data file with 31 sheets, and 1 report excel file.
The report excel file links to 31 sheets (days) of the excel data file, and I have formular like this:
The report excel file:
K2(Date): 12--> I will change this value everyday.
A5 (linked data from each sheet of the report excel file): =='4 Apr-10\[Apr-10.xls]12'!$W$38
so I want: when I change the value of K2 (Date) to 13, the link of A5 will change automatically to:
Please help me.