Copying Text from one tab to another if it contains certain characters.

[MoldyBread]

Hey All!

So I have database of about 300 rows of data and I want to copy rows over too respective tabs if Cell X contains Y.

I've been able to use sample code I found on here to accomplish this however, In my spreadsheet the data starts on the third row not the second can someone help a brother out and let me know how to change this. Simply setting the starting variable value doesnt seem to work for me. I'm stuck and would appreciate the help.I've attached the sample code I'm Working off of. Option Explicit

Please Login or Register  to view this content.

Matching cell to worksheet name then copy (1).xls

[AB33]

y = 2

to

y = 1