Thanks for the help. I think I've almost licked it. I'm close to getting that "man, I could *sell* this" feeling.
I've ended up using INDIRECT along with find/replace to change all my VLOOKUPs to point to the right files (brute force), and I made an extra sheet with all the running totals...
Hmmm. Perhaps I will have to concoct another way of doing this task. At this time next year, there will be over 500 tiny excel sheets to draw from for the annual production report. Clearly, opening all of them to update the master worksheet is not going to be fun.
The problem is that I...
I can't seem to get that to work either. Here's a formula that works to return the piece of information that I need:
='PUBLIC:_Production Reporting:[38391.xls]Day Totals'!$B$2
The cell B5 contains the text:
"38391.xls"
cell C5 contains:
="'PUBLIC:_Production Reporting:["&B5&"]Day...
I'm working on a production report. I have a large number of small excel sheets from all departments of the mine, and I want to pull information from them into my production report.
I have a column of file names (based on dates) like 38391.xls
Instead of typing...
