T O P

How to create a linked workbook

How to create a linked workbook

AutoModerator

/u/CleanWeekend496 - Your post was submitted successfully. Please read these reminders and edit to fix your post where necessary: * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


sancarn

Might want to clarify what you mean by "a bar" - do you mean a bar chart? Or a bar where someone eats? etc.


CleanWeekend496

Sorry, yes a Bar as in a place to Eat/Drink


sancarn

Sounds like a one drive folder containing your files and using PowerQuery's "files in a folder" setting would likely be your best bet to collate them. From there you can do whatever analysis is required.


Continuity_organizer

The way I would approach this would be to add a bit of VBA code to each bar's individual file which would create a separate output file which would be sent to a central location, either shared drive or through Email each time the manager updates it, say, by clicking on a "share with home office" button. Then you can take the 3 files, which are named, look and act the way you expect, and compile a master file from those, probably also using VBA.