I am creating a log sheet for work. Each employee will have their own seperate log sheet for each day. And for each day there will be a central log sheet which will contains sums of data from all of the employees log sheets.
What I want to do if possible is have a cell on a sheet in the central log sheet containing a file path which would then be used for obtaining data from the other sheets. The reason I want to this is that when i create copies of the log sheets for the next days/months etc rather than change the filepath in every formula I can just change the filepath in this cell.
From what I can gather this isn't possible but though theres a slight chance I may be wrong.
Hi,
This link might help?
http://excel.tips.net/Pages/T001968_...ing_Links.html
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
This is what I was looking for but I think using the INDIRECT function would be too much hassle. There would be links to like 30 other workbooks in the central log and I wouldn't want to have to open all 30 of them just to update it.
What im using now is the follwing to link:
The part I need to change is the year, month and day.='C:\Users\Matt\Desktop\Log Sheets\2010\April\01\[Matthew.xls]Stats'!$D$3
If you link to 30 other workbooks, you won't need to open and change these workbooks. You just need to create the text strings that represent the location of these workbooks and then wrap each text string in an INDIRECT formula in your central workbook.
It might be worth noting that INDIRECT does not work with closed workbooks, though. You'd need to have these workbooks open for the formula to work.
Alternatively, you can use the INDIRECT.EXT function, which does work on closed workbooks. It is available in the morefunc.xll, which can be downloaded from here: http://download.cnet.com/Morefunc/30...-10423159.html
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks