P
PurchaseGuy
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!
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!