Hello. I have a large spreadsheet containing several thousand parts for my business and their associated part numbers, cost, shipping, markup, retail price, etc. I also have a Publisher advertising document consisting of 50 pages with pictures of the products and a chart below the pictures containing several rows and columns displaying part numbers, shipping cost and retail cost. When my cost changes, I enter the new cost into the spreadsheet and the changes flow accordingly in the master spreadsheet. The difficult part is that I then have to change each table on each page of my Publisher document to reflect the changes in the master spreadsheet. I would like to insert a small part of the master spreadsheet into the correct Publisher document page and have that small spreadsheet update automatically when I make changes to the master spreadsheet. I am using MS Office 2010 Professional. Please tell me if what I would like to do is possible, and because I would like to know if I can do it myself, please tell me the procedure in very general terms. Thank you very much for your help.
Bookmarks