| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I copy a field from another spreadsheet based on search?
I have two spreadsheets each storing data about jobs we need to manufacture.
Spreadsheet A stores operation #1 and the workcentre it will be performed at, Spreadsheet B stores operation #2 and the workcentre that will be performed at. Not all jobs are in both Spreadsheet A&B, but for each job that is listed in both spreadsheets I need to put the workcentre from operation #2 in a new field (workcentre2) in Spreadsheet A, in the proper row for that job. Can this be done? Thanks for any advice, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I copy a field from another spreadsheet based on search?
You can use VLOOKUP to do this - Debra Dalgleish has some
comprehensive notes he http://www.contextures.com/xlFunctions02.html Hope this helps. Pete On Jul 14, 9:46*pm, Faye wrote: I have two spreadsheets each storing data about jobs we need to manufacture. Spreadsheet A stores operation #1 and the workcentre it will be performed at, Spreadsheet B stores operation #2 and the workcentre that will be performed at. * Not all jobs are in both Spreadsheet A&B, but for each job that is listed in both spreadsheets I need to put the workcentre from operation #2 in a new field (workcentre2) in Spreadsheet A, in the proper row for that job. Can this be done? Thanks for any advice, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I copy a field from another spreadsheet based on search?
Thanks Pete that looks very promising. I appreciate your help!
Faye "Pete_UK" wrote: You can use VLOOKUP to do this - Debra Dalgleish has some comprehensive notes he http://www.contextures.com/xlFunctions02.html Hope this helps. Pete On Jul 14, 9:46 pm, Faye wrote: I have two spreadsheets each storing data about jobs we need to manufacture. Spreadsheet A stores operation #1 and the workcentre it will be performed at, Spreadsheet B stores operation #2 and the workcentre that will be performed at. Not all jobs are in both Spreadsheet A&B, but for each job that is listed in both spreadsheets I need to put the workcentre from operation #2 in a new field (workcentre2) in Spreadsheet A, in the proper row for that job. Can this be done? Thanks for any advice, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I copy a field from another spreadsheet based on search?
You're welcome, Faye.
Pete On Jul 15, 2:50*pm, Faye wrote: Thanks Pete that looks very promising. *I appreciate your help! Faye |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy field settings of a field to other fields in same pivot tbl | Excel Worksheet Functions | |||
| calculate a field based on value of another field | Excel Discussion (Misc queries) | |||
| calculated field based on data field | Excel Discussion (Misc queries) | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
Linear Mode
