Rickard100
New Member
- Joined
- May 6, 2014
- Messages
- 1
Hi! I store weekly reports in a folder. A summary excel spread sheets gets cell information form these weekly reports. I would like to use a cell in the summary report to guide which weekly report that is showed in the summary file.
The link in my summary report look something like C:\reports\2014\[Week10.xls]Sheet1$B$10
So I would like a cell (e.g "A1") in the Summary File state the week, say I put in "Week11" I the cell. By that I would like my link to change to:
C:reports\2014[Week11.xls]Sheet1$B$10
As I have a lot o links in the summary file coming from in the weekly reports, this would be a huge help is somebody could help on this. Hopefully excel will not show warning for each cell link, as they are many that would give problem.
Thanks!
Rickard
The link in my summary report look something like C:\reports\2014\[Week10.xls]Sheet1$B$10
So I would like a cell (e.g "A1") in the Summary File state the week, say I put in "Week11" I the cell. By that I would like my link to change to:
C:reports\2014[Week11.xls]Sheet1$B$10
As I have a lot o links in the summary file coming from in the weekly reports, this would be a huge help is somebody could help on this. Hopefully excel will not show warning for each cell link, as they are many that would give problem.
Thanks!
Rickard