VBA Formula; Automatically update multiple workbooks from MASTER [Closed]

Report
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
Hello,

I am trying to help a friend with his restaurants.

There is a MASTER list with all the food/drink items.
There are 7 locations.
Each location has its own workbook with their own specific food/drink items.
Each location has the VLOOKUP formula attached to the MASTER list so each location gets automatically updated once the MASTER list is updated.

Let's say, for example, I would like to delete a column from the MASTER list and have that column automatically get deleted in each individual locations workbook. How would that VBA formula look?

Thank you for any input.


1 reply

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Hi Jr,

So each workbook has 1 sheet?! Why not create 1 workbook with 8 sheets? Then the task described is as easy as selecting all sheets and deleting the column.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!