Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match & combine rows from 2 worksheets
I have two worksheets w/ data that I want to combine into a single worksheet.
I want to combine rows based upon one column of data that each shares: worksheet 1: ID # Name State 1 Bob Ohio 1 Sue Utah 2 Joe Iowa Worksheet 2: ID# Location size 1 east 4 2 midwest 6 Combined Worksheet: ID# Name State Location Size 1 Bob Ohio east 4 1 Sue Utah east 4 2 Joe iowa midwest 6 I am struggling to figure this out. Any help would be much appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
MATCH function through multiple worksheets | Excel Worksheet Functions | |||
Link Rows Between Worksheets | Excel Discussion (Misc queries) | |||
Auto adjusting # rows between 2 worksheets | New Users to Excel |