| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to merge worksheets on a key - merge horizontally, that is
Suppose Sheet1 looks like this:
KEY|VALUE 100 | Chevy 200 | Honda Suppose Sheet2 looks like this: KEY|VALUE 100 | Corvair 100 | Corvette 100 | Impala 200 | Accord 200 | Civic How do I create Sheet3? 100|Chevy|Corvair 100|Chevy|Corvette 100|Chevy|Impala 200|Honda|Accord 200|Honda|Civic Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
| Zip codes in mail merge - first digit doesn't display in merge | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
Threaded Mode
