How do you copy an entire row in excel to a new tab based on a cell value

**pklimchuk** · 10-07-2010, 06:09 PM

How do you copy an entire row in excel to a new tab based on a cell value. Then delete the cell in the first sheet

**pike** · 10-07-2010, 09:35 PM

Hi pklimchuk
one way is like Peter SSs example ..

Please Login or Register  to view this content.

**pklimchuk** · 10-08-2010, 09:36 AM

Thank you very much

**pklimchuk** · 10-08-2010, 09:49 AM

It worked for the First part it copys the whole row to another sheet.

How can i Have it the macro remove that data from the first sheet and just have on the 2nd sheet.

Also the data is alwasy located in Colum AB and it will be specific to 14 diffrent numbers

**pike** · 10-08-2010, 05:53 PM

Hi pklimchuk
Very hard with out an example workbook
but put the 14 search values in sheet two a1 down to A14
and results will be returned in sheet three

Please Login or Register  to view this content.

**pklimchuk** · 10-11-2010, 10:56 AM

Thanks so much, almost there. Can we tweek it to remove the entire Row not just the sell and then remove the blank Rows

**pike** · 10-20-2010, 04:42 AM

Hi pklimchuk
try change this line by adding "entirerow."

Please Login or Register  to view this content.

How do you copy an entire row in excel to a new tab based on a cell value

LinkBack

Thread Tools

Rate This Thread

Display

How do you copy an entire row in excel to a new tab based on a cell value

Re: How do you copy an entire row in excel to a new tab based on a cell value

Re: How do you copy an entire row in excel to a new tab based on a cell value

Re: How do you copy an entire row in excel to a new tab based on a cell value

Re: How do you copy an entire row in excel to a new tab based on a cell value

Re: How do you copy an entire row in excel to a new tab based on a cell value

Re: How do you copy an entire row in excel to a new tab based on a cell value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions