Macro to Copy Rows if cell value equals

**oakleyfoy** · 09-03-2010, 12:04 AM

I have TWO worksheets. One named "td" the other named "archive"

I need to copy an entire row from sheet "td" if a cell in column R has the word "archive" in it. (Starting in row 2 of column R and continuning thru R500).

The copied row needs to be paste with format to worksheet "archive" starting in row 2. I need all row paste to append to the "archive" sheet from this point on, everytime i run the macro. Not starting over on row 2 each time.

Once the paste is done with the row, I need the macro to go back the "td" worksheet and delete the row completely that it just copied.

Please help!!!

**Trebor76** · 09-03-2010, 12:37 AM

Hi oakleyfoy,

Welcome to the forum!!

Unfortunately until you change your thread title I doubt anyone will respond to you for as it currently stands it doesn't comply with Rule 1 (refer here) of the forum's guidelines.

Once the title is changed I'm sure you'll get a response.

Robert

**Trebor76** · 09-05-2010, 08:57 PM

Hi oakleyfoy,

Thanks for changing the title - it really does help others searching the web if they have a similar problem.

Let me know how this goes:

Please Login or Register  to view this content.

Regards,

Robert

**ROSEY1** · 02-12-2011, 04:52 PM

delete rows where one cell value equals another cell value

--------------------------------------------------------------------------------
Hi

I am trying to match one column with another then delete the matching row.

e.g.

cell number = cell text then delete this row . These criteria both the text and number are variable,

The problem is that the text has a set number of values i.e.Red,Green,Brown,Black but the associated numeral values can include up to 500 numbers.

Therefore I'm after some VBA that I can run to do the following:

For a cell which has any number anywhere between 1 - 500, delete any row which has a cell which also includes either Red,Green,Brown,Black

I know guys I don't ask for a lot ...but this ones got me beat

Thanking anybod in advance...x : )