|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hi
It is a long time since I have used excel and need help I want to use an
invoice and the data to be inserted into a spreadsheet at the same time.
Must be my age cannot remember how it works.
Any help would be gratefully received.
Old Dodger Sue
|
|
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
|
|
Hi Travis
Yes they are both in excel and I will try a pivot table. Thanks for your
help
Sue
|
|
|