Hi,

I have a worksheet with raw data and now would need to go through every single row to check if column I is holding a specific number, and if yes, copy it to another sheet. totally there are several options where I need to copy to.

Cell value - sheet name
2660 - Blue
2200 - Cafe
2230 - Marcos
2290 - Vbar

So basically, if column I cell content is 2230, then copy the entirerow to sheet marcos. if value is 2290 then copy to vbar, if 2660 copy to blue, etc.
I did find several samples via google where this topic is explained, but the problem is that I have around 5000 rows of data and dont want to loop through the entire data 4 times to check one by one if there is a match...

Any suggestions are welcome!
Thanks,
A2k