Can anybody answer a hopefully quick excel question? Excel is biz.
I have five standalone workbooks. I can update them individually with new data by saving over them.
Data from four workbooks all consolidates on the fifth workbook.
All five workbooks are linked together with a full filepath (X:/Folder1/Workbook1.xls) and saved on a flash drive.
When I plug that flash drive into any other PC, it assigns a new drive letter, breaking all of the links in the consolidation workbook.
I'd also like to be able to send this folder of workbooks to somebody else, yet the network of data sources is only connected if their drive letter (and parent folder(s)) are all identical.
Can I command the consolidation workbook to look at fellow workbooks within its immediate vicinity (its own folder) to make this folder (and excel system) portable?
Jesus christ what a disaster of a post.
There's nothing worse than some retard trying to throw around technical terms they're totally clueless about.
Hey you stupid faggot, how about you just check the flux capacitor box?
>>1649282
2/10, wouldn't do business with.
>>1649250
I understand what you're asking but I'm not going to help you
>>1649331
correct
Use the UNC file path and excel won't do this.
I had to do this when deploying an excel solution across our network.
Have you tried vlookup?
>>1649331
The main reason is the end-user, who has to update these workbooks.
Telling Pam in HR to (perfectly) copy columns B:L from one to another each time she wants an updated readout is a guaranteed trainwreck.
My employer doesn't have a sharepoint or centralized storage, so telling Pam to save over old workbooks saves me troubleshooting calls when she encounters a paste over merged cell error or she shifts a column.
>>1649350
If you set up an index match or vlookup on B:L with the relevant filenames they should update when she has both sheets open. F9 to force recalculate if it doesn't.
>>1649282
This.
All of this is a mess and VBA would make all this so much simpler
I can fix all that and make it more efficient (automated with a button click) if you're interested. but I'd charge you for it