| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and merge on new worksheet
Need some help with the following:
I've got two worksheets that are exports of two separate reports. The first worksheet has 6 columns of data that I need to append to the data in the second worksheet. If possible, it would be great to have the merged records written out to a third worksheet. Additionally, I need to match the records in sheet 1 with the records in sheet 2 by a text field (Project Name). Is there a relatively easy way to do this in Excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO MERGE TWO TABLES | Excel Worksheet Functions | |||
| I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions | |||
| F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) | |||
| Merge Data from Multiple Spreadsheets | Excel Worksheet Functions | |||
| Match/ Merge columns | Excel Discussion (Misc queries) | |||
Threaded Mode
