View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
travis
 
Posts: n/a
Default LINK EXCEL INVOICE TO A SPREADSHEET

I'm not sure what you are trying to do.

What format is the invoice in? Word?

If what you are trying to do is make data from specific cells in Excel
appear in a Word document, just ctrl c (copy) them one at a time from
Excel and then special paste with a link in Word (edit, paste special,
<link, unformatted text).

If you have problems with links moving around, i.e. if you add an extra
row above a linked cell and all the links in the word document now
point to the cell above the one you are interested in, you can get
around that by naming cells before linking them. You can also slect an
entire range and name that, so the table stays linked properly in Word
even if you add or delete rows and columns.

If both the invoice and the data are in spreadsheet format, but you
want to filter the data somehow to get only the data you want, you may
need to create a pivot table.

A clearer enunciation of what you are trying to do would help...

Travis