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.
VBA Formula; Automatically update multiple workbooks from MASTER