| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Att data from one sheet to another
I have a rather large database with two sheets of data. I want to take sheet
two and put the data in column C to sheet one column C where A and B match on both sheets. Sheet One A B C 1 100 4 2 200 1 3 200 2 4 200 5 Sheet Two A B C 1 100 4 CAR12 2 100 4 WIL13 3 100 4 CAR14 4 200 1 CAR15 5 200 1 CAR16 6 200 2 CAR17 7 200 5 WIL18 What the result should look like A B C 1 100 4 CAR12; WIL13; CAR14 2 200 1 CAR15; CAR16 3 200 2 CAR17 4 200 5 WIL18 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| Hyperlinking from data in one sheet to matching data in another sheet | Excel Worksheet Functions | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Threaded Mode
