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
|