Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't get it... - Merging
I need to merge unique values from multiple sheets in one excel file in such
as way that the end result is a list in number order on the merge sheet. I want to be able to expand it in the future, though currently I have 4 sales people. A.K.A. - Merge 2009 Sales.xls Tab 1 = Saleman #1 Column 1: Order # 10001 10002 Column 2: Customer: Customer Name Customer Name Tab 2 = Saleman #2 Column 1: Order # 20001 20002 Column 2: Customer: Customer Name Customer Name Etc. into an existing workbook in a 2009 Sales sheet: Column1: Salesman #1 Order 1 Salesman #1 Order 2 Salesman #1 Order 3 Salesman #2 Order 1 Salesman #2 Order 2 Salesman #2 Order 3 Column2: Salesman #1 Customer Name Salesman #1 Customer Name Salesman #1 Customer Name Salesman #2 Customer Name etc. The list needs to grow as we make sales so that current customer information is available. Auto update is a plus. I just don't get this VBA thing and don't have money to hire someone. Please Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help on merging | Excel Discussion (Misc queries) | |||
Merging | Excel Discussion (Misc queries) | |||
Merging | Excel Discussion (Misc queries) | |||
When merging information not merging correctly | Excel Worksheet Functions | |||
Sorting, Merging, and Re-merging | Excel Worksheet Functions |