We help IT Professionals succeed at work.
Get Started

Excel 2007 Dynamic Link To Another Files.

JameMeck asked
Last Modified: 2012-05-09
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:
'4 Apr-10\[Apr-10.xls]13'!$W$38

Please help me.
Watch Question
Most Valuable Expert 2011
Awarded 2010
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE