Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Merge 2 files with same acc# in each file
I would like to merge data from one workwheet into another and combine the
data. Both WS have a account # as one the column. Would like all the data associated with Acc# 123 in WS 1 to combine with all the data in WS 2 for Acc# 123 to merge. WS 1 WS 2 Acc# Name Amount Acc# City QTY Name 123 Jones 39.95 123 Anytown 4 Jones This is what I would like to happen....can this be done? Kate Merged WS1 and WS 2 Acc# Name Name Amount City QTY 123 Jones Jones 39.95 Anytown 4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you merge many files into one file with several worksheets? | Excel Discussion (Misc queries) | |||
How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
MERGE 2 FILES | Excel Discussion (Misc queries) | |||
How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
how i can merge more than two excel files in one file. | New Users to Excel |