copy row to other sheets depending on cell value (multiple values!)

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

Please attach a sample and will write you a faster code.

My current very simple attemp for your reference.

Please Login or Register  to view this content.

Thanks,
A2k

You can shorten it

Please Login or Register  to view this content.

hmm... well, why not, its something

I guess there is absolutely no way for me to have an elegant solution like

Please Login or Register  to view this content.

bummer.
But thanks a lot for the help.
A2k

Of course you can have; I did not notice that you are copying in to the same sheet.

Please Login or Register  to view this content.

Madly in love with you AB33,
thanks a lot
A2k

congokin,
You need to start your own thread. Please read forum rules.