Help with macro please

[Beekman]

I have sheets named Monday thru to Friday
In Col A from A10 Have a list of numbers.(4 digits)
Some numbers end with a M,U,W,T,F

Want to delete rows with any numbers ending with U,W,T,F In Monday,

M,W,T,F in Tuesday, M,U,T,F in Wednesday, M,U,W,F in Thursday,

M,U,W,T in Friday and move rest of rows up

Is there a macro I can use for all days at once or would it be better a seperate one for each day?

Thanks, in advance, Ben

 

[Beekman]

Thanks to all for your help . Tried again with A.D. Taylor's version and everthing works fine.

Just as a extra querie is it possible to modify to delete duplicated number related to number with text, for example with Monday in the list of numbers with letter ''M' numbers without ""M" exist above it eg


4100
4101
4102
4102M
4103
4103W
4104
4125
4125M
4126
4157F
etc

As in 'Taylor's' and 'Weaver's' macro it deletes all other letters except M
but where 4102M stays I would like also to delete 4102 and 4125 and any corresponding number the same as ending with 'M'. Hope you understand what I'm trying to achieve. Happy with the way macro works, so i could just delete these rows manually if no solution

 

[Weaver]

Thanks to all for your help . Tried again with A.D. Taylor's version and everthing works fine.

Just as a extra querie is it possible to modify to delete duplicated number related to number with text, for example with Monday in the list of numbers with letter ''M' numbers without ""M" exist above it eg


4100
4101
4102
4102M
4103
4103W
4104
4125
4125M
4126
4157F
etc

As in 'Taylor's' and 'Weaver's' macro it deletes all other letters except M
but where 4102M stays I would like also to delete 4102 and 4125 and any corresponding number the same as ending with 'M'. Hope you understand what I'm trying to achieve. Happy with the way macro works, so i could just delete these rows manually if no solution

AD_Taylor - thanks for the tweak - although the version as posted did work on my dataset, probably because I was testing on one sheet only. You're right about the xlup not being necessary, I still use xltoright when deleting columns too!

Beekman - what you're suggesting is possible but I'm thinking would require a fair amount of tweaking. I can take a look at it later if nobody else has come up with a solution.