Hello,
I'm trying to create a macro to find a value from a list and copy the row containing the value to a new worksheet. i tried recording a macro and tweaking it but my lack of knowledge prevented a successful tweak. This is the scenario: i have a list of 500 addresses in col A of sheet1. The data to be searched is in sheet 2. I thought the quickest and best way to find and group the data I need would be to search for the address from the list and copy the row to a new worksheet if the address matches the list. Any suggestions would be helpful. Thanks in advance.