Macro to move data from one sheet to another

**KMD1** · 08-25-2012, 06:45 AM

Hi, first time poster here so I hope I've explained the problem clearly.

I need a macro that moves data from one sheet to another if certain conditions in the first sheet are met - a mock up is attached which hopefully shows what is needed.

This has been driving me mad so any help would be really appreciated.

Many thanks, Karen

**nested.if1@gmail.com** · 08-25-2012, 07:11 AM

Please Login or Register  to view this content.

**HaHoBe** · 08-25-2012, 07:21 AM

Hi, nested.if1 @ gmail.com

please use Code-Tags for the readability of your code.

And when deleting rows it´s very good to start at the bottom and work up (then there´s no need to manipulate the counter. Instead of

Please Login or Register  to view this content.

Please Login or Register  to view this content.

BTW: as I handle both *.xls and *.xlsx/*.xlsm I changed from hard coding the last row with 65536 to using Rows.Count which will always deliver the proper number of rows in a worksheet. And I avoid hopping between worksheets - but that´s of no great interest here (I´d used Autofilter and copied the visible cells and then deleted them - just as an alternative approach)).

Ciao,
Holger