Copy row from Sheet 1 to Sheet 2 when data entered in cell F

**tony0710** · 07-09-2009, 06:49 PM

Dear All

I have Worksheet 1, with columns A to E.

I would like a row to be copied to Worksheet 2, as soon as cell F in Worksheet 1 is populated.

Also the row to be deleted from Worksheet 1.

So, as soon as F1 in worksheet 1 is populated and enter button pressed, row A1:F1 will be copied to the next empty row in worksheet 2, while being deleted from worksheet 1.

So eventually all rows in worksheet 1 will be deleted and rows in worksheet 2 will be populated.

All help will be greatly appreciated.

**rylo** · 07-09-2009, 09:25 PM

Hi

Right click on the sheet tab, select view code, and paste in

Please Login or Register  to view this content.

Now if you put something into a single cell in column F, it will move the data to the second sheet in the workbook.

HTH

rylo

**tony0710** · 08-16-2009, 08:55 AM

thanks that worked really well.

All solved - but cannot edit the post to read solved

**tony0710** · 05-29-2010, 07:32 PM

Hi

Thanks to all who helped and gave the following code:

Please Login or Register  to view this content.

Basically this code moved a whole row from sheet 1 to sheet 2, when user inputs into cell F of sheet 1.

Well now I have a sheet from a to aa, so how do I edit code to do the same - i.e.copy row from sheet 1 to sheet 2, if cell "o" = "cash exp". cell "o" will automatically get the info from a vlookup function.But not delete the row in sheet 1.

regards

**NCSurfer** · 01-27-2011, 06:16 PM

Originally Posted by tony0710

Hi

Thanks to all who helped and gave the following code:

Please Login or Register  to view this content.

Basically this code moved a whole row from sheet 1 to sheet 2, when user inputs into cell F of sheet 1.

Well now I have a sheet from a to aa, so how do I edit code to do the same - i.e.copy row from sheet 1 to sheet 2, if cell "o" = "cash exp". cell "o" will automatically get the info from a vlookup function.But not delete the row in sheet 1.

regards

If Target.Column = 6<<<<<Change this number to the number that coinsides with the letter "O". Then everything in the row will be removed and copied onto the sheet of choice

**fabjay** · 10-12-2011, 02:23 PM

I'm looking to do the same. However I do not want any rows to be deleted. And instead of the row copying in a different sheet, I would like the row to be copied in the same sheet but below starting at row 208 and below, for example. I am working with a price list and the bottom is an purchase order. If customer is reviewing price list they can make a selection same selection will be itemized below.

Can you help me edit the above code, please?

**arlu1201** · 10-12-2011, 02:39 PM

Fabjay,

It will be advisable to create your own thread with this question. You can provide the link to this old thread as a reference. This to avoid any infractions from the moderators.