hunter122976
New Member
- Joined
- Mar 31, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hope I can explain this, so it makes sense...
I have around 20 customers that I have to keep prices on. Each customer has it's on folder with workbooks I've named for each style they have. Some of the customers have close to a hundred styles 'workbooks'. The workbooks each have formulas in them, to allow me to decide what price to use for the items contained in the workbook. Also each workbook has 25 sheets each, that contain the data of the items to be priced. Depending on the number of items in the style, I don't usually have to use all 25 sheets, but have them incase I need them. Each workbook also has a sheet named 'Costing' that is a compilation of all the info from the 25 worksheets. All of these workbooks use Vlookup that pulls from one MasterPriceList. I've created a new workbook for each customer, that contains all the info from the Costing Sheet for each style (workbook) the customer has.
Is there anyway, that when I change the prices in the MasterPriceList, that the new workbook I've created, that contains the Costing Sheet for each style for a customer, will automatically update, when I open it. Right now, I have to physically open each style (workbook) to be able to see the change made to the MasterPriceList. Hope all of this makes sense.
Thanks in advance.
I have around 20 customers that I have to keep prices on. Each customer has it's on folder with workbooks I've named for each style they have. Some of the customers have close to a hundred styles 'workbooks'. The workbooks each have formulas in them, to allow me to decide what price to use for the items contained in the workbook. Also each workbook has 25 sheets each, that contain the data of the items to be priced. Depending on the number of items in the style, I don't usually have to use all 25 sheets, but have them incase I need them. Each workbook also has a sheet named 'Costing' that is a compilation of all the info from the 25 worksheets. All of these workbooks use Vlookup that pulls from one MasterPriceList. I've created a new workbook for each customer, that contains all the info from the Costing Sheet for each style (workbook) the customer has.
Is there anyway, that when I change the prices in the MasterPriceList, that the new workbook I've created, that contains the Costing Sheet for each style for a customer, will automatically update, when I open it. Right now, I have to physically open each style (workbook) to be able to see the change made to the MasterPriceList. Hope all of this makes sense.
Thanks in advance.