Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
LINK EXCEL INVOICE TO A SPREADSHEET
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
LINK EXCEL INVOICE TO A SPREADSHEET
Hi Travis
Yes they are both in excel and I will try a pivot table. Thanks for your help Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
Link pictures in Excel 2003 doesn't work! | Excel Discussion (Misc queries) | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
Excel Spreadsheet and Invoice Forms | Excel Discussion (Misc queries) | |||
Link from webpage to excel sheet | Excel Discussion (Misc queries) |