Dan Wilson
Well-known Member
- Joined
- Feb 5, 2006
- Messages
- 546
- Office Version
- 365
- Platform
- Windows
Good day. I am using Excel 2007 on windows Vista Business 32 bit. I have a folder containing 80 workbooks, all using the same format, each one being a different product from my store. I have used the INDIRECT.EXT function in these workbooks to allow me to reference values from closed workbooks. One of the workbooks being referenced contains product costs that are routinely updated from Quickbooks. Every time that I open one of the product workbooks, I can see that the values are being updated as the workbook opens. It has now become necessary to update all 80 of the product workbooks at one time to allow me to make changes to my selling prices.
Is there a way to open each workbook in the product folder, save the updated values and move on to the next workbook? I need to do this to each of the 80 workbooks in the folder.
As always, thanks for any help with this.
Is there a way to open each workbook in the product folder, save the updated values and move on to the next workbook? I need to do this to each of the 80 workbooks in the folder.
As always, thanks for any help with this.