| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Retreive information from One Sheet to Another
Hi.
I have an excel document with two sheets. On sheet 1 I have a list of items with three columns (Part Number, Description, and Supplier). On sheet 2 I have an invoice template with three columns. (QTY, Part Number and Description). What I want to do is that whenever a part number is entered on the invoice, the description field to be filled automatically using the information from the list on sheet 1. How is this accomplished? Thanks in advanced! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy subtotal information to new sheet | Excel Worksheet Functions | |||
| Import data file but exlude information I already have in sheet? | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Copy formula...sheet 2 sheet | New Users to Excel | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
