[Excel2010] Vlookup-esque function that copies the entire row of each match into new sheet

[zbrt]

Hi all--

I've been lurking around this sub for a while now, this is the first problem I've encountered that I haven't been able to find a solution to online.

So, I have a large (~10k line) spreadsheet that my company uses for scheduling. I've found a macro online that allows me to input a string into a prompt, then the function finds all instances of that string in the spreadsheet and copies each row with a hit on it to the next sheet.

My problems are twofold as of now:

I'd like to be able to input a list or table of strings and have it just output the rows of each hit to the new sheet in one fell swoop, partly because...
When I run the macro more than once, it overwrites the previous output.

Does anyone have any experience writing something like this?

I'll list the code below.

Please Login or Register  to view this content.

[AlphaFrog]

When I run the macro more than once, it overwrites the previous output.

To not overwrite the data on Sheet2;

Change this...
j = 1

To this...
j = Sheets(2).Range("A" & Rows.Count).End(xlUp).Row + 1

[zbrt]

Awesome!

That works perfectly!

Now I suppose my only issue is getting the input to not be a single string at the time but rather a list of strings, i.e. a sheet with cells A1:A55 each containing a string, and the loop runs searching each one down the line until the end.

I'll keep fiddling with it, thanks again!

[AlphaFrog]

Please Login or Register  to view this content.