| 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, |
| 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 | |||
Threaded Mode
