VBA Formula; Automatically update multiple workbooks from MASTER

Closed
Jr - Jun 11, 2016 at 06:24 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2016 at 11:58 AM
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.


Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 13, 2016 at 11:58 AM
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