Copy and paste in other cells while typing in different cells

**go4cdt** · 06-10-2009, 12:05 PM

Hello everyone;

I have to enter info daily in column H. What I wanted to do is as I finish entering info in cell H3, infomation in row 2(cell A2:E2) is copied and pasted down to row 3 (A3:E3) and will continue about 100 rows down daily.
Thanks in advance for everyone's help.

Cdt

**JBeaucaire** · 06-10-2009, 01:03 PM

So the values in row 2 act like a template for each new row you start when you enter a value in column H on a currently blank row? This would be simplest as a worksheet_change event.

Right-click on the sheet tab and select VIEW CODE, then paste in this event macro:

Please Login or Register  to view this content.

It will warn you if you ever edit a value in column H on a row that already has A:E filled in, give you a chance to NOT update the values from the template row.

**go4cdt** · 06-11-2009, 01:18 PM

Hi JBeauCaire;

Is there anyway to kill all the popped up messages? It works but the problem is I have to erase data in column H (H2:H100) and all data in column A:E daily then I will have to close all the popped up windows that appear for every cell I delete (100 times).
Appreciate for your help.
Cdt

**go4cdt** · 06-11-2009, 01:25 PM

Never mind! I figured that out. Thank you so much

**JBeaucaire** · 06-11-2009, 02:50 PM

OK, was going to suggest you leave the popups for normal daily use, and when you need to do some major "resetting", just click on the Control Toolbox Toolbar's DESIGN MODE icon...that disables all macros temporarily, click it again to resume normal operation.