Macro Needed to Auto-Populate Rows Based on the Conditions of a Cell

**lago3525** · 09-11-2012, 03:00 PM

I looked around on the forums and can't find a macro that fits my needs. I have a cell that is preforming a COUNTIF function: =COUNTIFS(Main!BM:BM,"No",Main!CQ:CQ,"No") and I need a macro which will copy the rows for any which match the conditions listed and auto-populate the current worksheet.

I am also wondering if there is a formula which could achieve this. I was thinking I could do something to the effect of =IF(COUNTIFS(Main!BM:BM,"No",Main!CQ:CQ,"No"),TRUE,FALSE where the value if TRUE populates the rows meeting the COUNTIF conditions; I'm just unsure of a formula which could do this.

Thanks!

**TMS** · 09-11-2012, 03:21 PM

I'm sure there is a formula but I'd be inclined to go with an Advanced Filter with crews "No" on those columns and "Copy to Another Location".

If it's something you do regularly you could record and tweak a macro.

Regards, TMS

**avasp** · 09-11-2012, 04:24 PM

HI,

I have the same issue. I am trying to populate rows in to a new workbook based on the condition of the cell after formatting the same. I am able to conditionally format the cells using VBA but unable to figure out how to copy those entire rows to a new workbook.

any help would be appreciated.
Thanks in advance

**zbor** · 09-11-2012, 04:35 PM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.