move entire row to another worksheet based on cell value

[Berndene]

Hi,

I have a similar scenario as to the link below:

http://www.excelforum.com/excel-prog...ell-value.html

I see that this Spreadsheet has been solved, I had a look at that spreadsheet and it works perfectly..
I tried to use that codes and just change the sheet names and destinations, but with no luck.

I have a large Workbook, with a main sheet (with all outstanding orders), and 11 sheets for distributors. On the main sheet Column "T", Order Status has Data Validation, where I'd like to choose eg. "1st Distribution" and that whole row must be moved (and deleted) to the "1st Distribution" sheet and so forth for the other Distributor's sheets..
All the sheets columns and rows are exactly the same to make the coding easier to work - after I've done this, I'll hide rows that I don't need in that sheet..



I'll appreciate some help on this

Please let me know if someone will be able to help me

Much Appreciated
Berndene