Checking then copying information

Steve - Aug 6, 2010 at 07:41 AM
 Steve - Aug 6, 2010 at 11:37 AM

I am trying to use VBA to check whether an M appears in column B and then if it does, paste the information from that row (A through to W) into another existing sheet in the workbook. I want this to be able to check the whole worksheet and then finish when it gets the the end of the information in column B.

Any ideas, I have been playing around with it for about 4 hours and have got nowhere!!!

Help me please!

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 6, 2010 at 11:07 AM
Isnt it same as your later question ?
Yes. Didn't think this question had gone on as I couldn't see it!!!

School boy error!