vba - copy entire row based on cell value

i want to search sheet("1").range("S:S") for str1 = "23320"
and if found, copy the entire row to sheet("2").range("next available row").

I have tried tweaking multiple codes that i have found but can't seem to get any to work right.

there will be upto 100 different Str's to search on sheet ("1"), some Str's will be copied to sheet("3"), ("4") etc. this i think i can do myself once i get a code to work for the first part.

Thanks in advance for any help!

I think this will do what you want.

Please Login or Register  to view this content.

I have a similar question to this. Let me preface this problem with the disclaimer that i know next to nothing about VBA, so i'm not able to modify the existing code. My problem is almost exactly the same. I want to search the sheet2(historical) look for today's date in column A. When found, i want all of those rows copied, and then pasted special values.(to change the formulae i have in there to hard coded numbers.) The data that i'm pulling from is an external database query that changes everyday, but i want to keep all the records for my group easily.

Trying to revive this old thread -

I am doing something similar and was able to use this code; however, I have several matches that I am trying to copy to another sheet. This particular code stops at the first one. How do I loop this for multiple matches?

Ultimately, I am creating a spreadsheet to track units through a process. I have a tab for each phase of the process. As a unit goes through this process, I have a pulldown menu in a column to indicate which phase of the process said unit is in. What I'd like to do is have the phase tab populate automatically when a the status of that unit is changed.

Any assistance is highly appreciated.