Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
updating excel worksheets to another workbook | Excel Worksheet Functions |