Here is my problem.
I have two spreadsheets. I need to be able to match information from detailed spreadsheet for specific information from a lookup spreadsheet.
The detailed sheet (call it Purchases) has information about what was purchased during a month.
Columns:
A (CustomerID) B (How much purchased) C (What was purchased) D ( Quantity purchased)
ex)
A B C D
1234 $12.00 Hex Nuts 12
1111 $1.00 Cancy bar 1
1011 $100.00 Lawn Chair 1
The specific information sheet (call it preferred) contains a list of what customers are "Preffered" so only a few customers will show up.
Columns:
A (Customer ID) B (Name) C (Address) D (City) E (State) F (Zip)
ex)
A B C D E F
1111 Joe Blow 123 Main St New York NY 10000
What I want is a way to create another sheet that will list the information from the purchase spreadsheet for the customers from the preferred spreadsheet.
I can envision that this will be done with a Macro using VBA. I will have to admit I am very novice. I may understand the concept, but I do not know how to code to VBA part.
Ultimately I think my idea would be to have my third sheet (preferred purchases) to run the macro. It would have to resad the detailed sheet and be able to read the summary sheet and produce output for those customers who actually matched. This preferred purchase spreasheet would have the same format as the purchases spreadsheet but it would not have all the data in it from the purchases just for that purchase where the custid from purchased equals the custid from preferred.
Any ideas?
I have two spreadsheets. I need to be able to match information from detailed spreadsheet for specific information from a lookup spreadsheet.
The detailed sheet (call it Purchases) has information about what was purchased during a month.
Columns:
A (CustomerID) B (How much purchased) C (What was purchased) D ( Quantity purchased)
ex)
A B C D
1234 $12.00 Hex Nuts 12
1111 $1.00 Cancy bar 1
1011 $100.00 Lawn Chair 1
The specific information sheet (call it preferred) contains a list of what customers are "Preffered" so only a few customers will show up.
Columns:
A (Customer ID) B (Name) C (Address) D (City) E (State) F (Zip)
ex)
A B C D E F
1111 Joe Blow 123 Main St New York NY 10000
What I want is a way to create another sheet that will list the information from the purchase spreadsheet for the customers from the preferred spreadsheet.
I can envision that this will be done with a Macro using VBA. I will have to admit I am very novice. I may understand the concept, but I do not know how to code to VBA part.
Ultimately I think my idea would be to have my third sheet (preferred purchases) to run the macro. It would have to resad the detailed sheet and be able to read the summary sheet and produce output for those customers who actually matched. This preferred purchase spreasheet would have the same format as the purchases spreadsheet but it would not have all the data in it from the purchases just for that purchase where the custid from purchased equals the custid from preferred.
Any ideas?