ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Updating worksheets from another file (https://www.excelbanter.com/links-linking-excel/53378-updating-worksheets-another-file.html)

Sonic

Updating worksheets from another file
 
I have a pricing book that was created in Excel with a menu page. I have
added some columns to allow me to put quantity, margin, extended price, etc
to this price book. Every month, my company releases a new price book,
however, periodically there are new products on it. How can I have Excel
automatically copy the new menu page along with the new corresponding pricing
to my original book so I can add the columns necessary for the new products.
I can update pricing on all existing products, but I want to add the new ones


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com