Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
one step update
we have a invoice spreadsheet which gets firgures fron a another spreadsheet
& makes invoice for ex: invoice column 1= Quantity invoice column 2= Descriptition invoice column 3= Price invoice column 4= Total Field 1= Name Field 2= Add Field 3= City in the other spreadsheet we have columns with all description of these column , we like to be able to pick row 36 from other spreadsheet and the whole info shall be transfered automatically how can we do it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
one step update
There has to be a common element to both spreadsheets (Ex invoice # or
something). The common element has to be unique (no other row can have the same value). Then you could use the VLOOKUP function to pull in all the other data once you have entered the "common element". "dk" wrote: we have a invoice spreadsheet which gets firgures fron a another spreadsheet & makes invoice for ex: invoice column 1= Quantity invoice column 2= Descriptition invoice column 3= Price invoice column 4= Total Field 1= Name Field 2= Add Field 3= City in the other spreadsheet we have columns with all description of these column , we like to be able to pick row 36 from other spreadsheet and the whole info shall be transfered automatically how can we do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
one step update | Setting up and Configuration of Excel | |||
Excel Links Update | Links and Linking in Excel | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) |