Help with a conditional macro?

Solved/Closed

Steve - Aug 6, 2010 at 09:33 AM
Steve - Aug 7, 2010 at 06:48 AM

Hello,

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 (Columns 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!!!

Can anyone help me please?

Help with a conditional macro?
Spell number in excel without macro - Guide
Macro excel download - Download - Spreadsheets
Excel macro to create new sheet based on value in cells - Guide
Run macro on opening workbook - Guide
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 6, 2010 at 11:05 AM

Well from what I see
1. loop thru each loop
2. use "=" or instr (depending if it is a exact match or contains match) to check for M
3. If found copy the row and paste to other sheet
4. move to next row

rinse and repeat

Steve
Aug 6, 2010 at 11:40 AM

Thanks for thatl. It's kind of what i thought I should be doing. Any ideas on the what the coed should look like. I am no good at getting it from scratch. Much better at finding a solution if thats possible and then changing it to suit my needs.

Cheers mate

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 6, 2010 at 04:43 PM

Have you tried to use macro recorder. That can be a good step one

Steve
Aug 7, 2010 at 06:48 AM

I'll do that right now. Thanks

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Automatically Run Macro from a calculated cell value change

Execute Macro On Calculated Cell change

Code for macro that conditionally inserts rows

Similar discussions

Subscribe To Our Newsletter!