Copy Rows That Match Variable Criteria And Paste To A New Worksheet

**BrodyNoochie** · 03-15-2012, 02:08 PM

I have a worksheet with various sales results. It is constantly updated and I use it to try and determine market trends. The only geographic identifier is area code so i would like to create a macro where i can type in multiple area codes into "sheet1" then have it search the area code column of the "sales results" sheet for each area code I am looking for. Then, when it finds one, to copy the entire row and move it to the "results" sheet.

Does anyone have an idea of how to do this?

**jraj1106** · 03-16-2012, 12:52 AM

Give some sample data...

**BrodyNoochie** · 03-16-2012, 10:45 AM

I have attached some sample data

the AccountDetailReport is the general data
the search tab is where I would like people to be able to enter their area codes and/or states (I currently have it set up as two seperate columns but if one column where they can enter area codes and states is easier, that would also work)
The results tab would be where the search results are pasted
In my attached example, someone would search for area codes 616, 216, and the state of CO and the results tab shows what I want the accounts the macro would end up with.

My goal for the macro is to only search for matches in the area code and state columns (I wouldn't want an area code to by chance match a total sale amount and have the macro pull that account over). And when it finds a match, to copy and paste the entire row into the results tab.

Thanks for the help

**jaslake** · 03-16-2012, 05:01 PM

Hi brodynoochie
The code in the attached takes a different approach...see if it works for you.

PS: well, it seems the file has some data (or something) it doesn't like...I'll see if I can fix that.

**jraj1106** · 03-17-2012, 12:35 AM

Hi..

Try this macro..

Sample Data.xlsm

**jaslake** · 03-17-2012, 05:06 PM

Hi brodynoochie
This file seems to be better accepted

**BrodyNoochie** · 03-18-2012, 01:21 AM

Many Thanks to you both. I haven't had a chance to try these out yet but as soon as I do, I will let you know how it goes. Hopefully it not only works but I am also bound to learn something. Thanks again!

**BrodyNoochie** · 03-19-2012, 04:20 PM

Both solutions offered worked. I think I will incorporate the logic of both of them into my sheet in one capacity or another. I just started toying with the code this afternoon and it has been working great. Thanks again