Search string in a column then copy entire rows to another sheet

**vannylette** · 10-03-2011, 04:26 AM

Im new to VBA and would really appreciate if anyone can help me with this.

I have a sheet with the range of A1:X15000. I'd like to search for a string in column C using an input box and then copy entire rows to another sheet including the header.

hope you can help me.

**arlu1201** · 10-03-2011, 04:56 AM

It will be good if you can provide a sample workbook. We can provide you the code, otherwise you will have to do a lot of changes at your end.

**incjourn** · 10-03-2011, 08:02 AM

I would use the match formula.

Please Login or Register  to view this content.

N.B. your search term is in 'A1'.

**Marcol** · 10-03-2011, 08:54 AM

I suspect there is more to your question to come, however try this as a starter

Please Login or Register  to view this content.

**BillNally** · 11-12-2013, 12:16 PM

Hi All
New here and complete newbie to excel (using 2007)
I’m working in a school and I was wondering if I could adapt this to search a column (in this case m) for any grades of >0 to <0.6 and copy those rows to another sheet and then do the same for >0.6 to <0.8 and move those rows to a new sheet and so on through around 10 searches.
Thanks in advance for any help