Moving rows of data from one worksheet to another depending on a cells data.

[Ranny30]

Hello,

I have a spreadsheet with 3 worksheets. They are called Todays Totals, A and B.

I want a macro that will search todays totals worksheet and if it finds E1, E5 or E7 in column C for any row, it will copy that row to worksheet A starting off at row 2 because row one has headings in.

I also want to send any row that has dm, dma, dms to worksheet B starting off at row 2 because row one has headings in.

cheers

Ran.

[Ranny30]

Can anyone help ?