mfrax
asked on
Excel 2003 sort macro
I've never built a macro and I have two spreadsheets. One has customer number, customer name and address. The other has customer number, customer type and date. I would like to create a spreadsheet from these two that selects a customer number based on customer type and date then using the selected customer number moves the customer name and address to the third spreadsheet. What would this macro look like?
could you post some example, mainly how the 3th sheet should looks like?
ASKER
Yes, thanks, I can post without sheet 3 completed also. [embed=file 679844 Test data with results on sheets.]
TestBook1-Result.xls
TestBook1-Result.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fast and perfect, byundt, you are very smart. Thanks, I will be studying this VB app.
ASKER