Hi,
I've got a very interesting problem.
I've got 2 workbooks:
#1)Is a massive listing of accounts with unique account numbers in column A, and various other data pertaining to each account in about the next 7 columns
#2)Is a workbook with about 8 different sheets, all with specific names of "groupings" that the accounts from workbook 1 should be placed into, and each sheet has a list of the account numbers which make up that grouping.
What I am trying to do is get a macro that will separate workbook #1 into the groupings as per workbook 2. I want a separate workbook (or worksheet, whichever is easiest for me and the code)
Also, if the macro finds an account number in workbook 1 that is not in workbook 2, is it possible to generate a list of these?
I really appreciate anyone who can help me. I know this is possible, I just really don't know where to start.
Thanks,
Macdian
I've got a very interesting problem.
I've got 2 workbooks:
#1)Is a massive listing of accounts with unique account numbers in column A, and various other data pertaining to each account in about the next 7 columns
#2)Is a workbook with about 8 different sheets, all with specific names of "groupings" that the accounts from workbook 1 should be placed into, and each sheet has a list of the account numbers which make up that grouping.
What I am trying to do is get a macro that will separate workbook #1 into the groupings as per workbook 2. I want a separate workbook (or worksheet, whichever is easiest for me and the code)
Also, if the macro finds an account number in workbook 1 that is not in workbook 2, is it possible to generate a list of these?
I really appreciate anyone who can help me. I know this is possible, I just really don't know where to start.
Thanks,
Macdian