Inserting entire row on a specific permanent spot using macro

**sphinx718** · 08-20-2012, 08:19 PM

Hi all,

I want to create a macro where it will insert an entire row on the same spot regardless of which cell is selected. I'm new in VBA and only know how to record, but not write a macro.

Please Login or Register  to view this content.

I currently have this code. What I want to do is insert a new entire row on the second row. I want it to use the same format from the 3rd row. I basically have a manual form on sheet 1 where i would enter all the data and it would record the information on sheet 2. All data copied from sheet one should be entered in the new row.

Hope you can help me. Thanks!

**Cutter** · 08-20-2012, 09:28 PM

@ sphinx718

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**sphinx718** · 08-20-2012, 09:30 PM

Understood. Thanks!

**sphinx718** · 08-20-2012, 11:31 PM

I have attached the sample workbook I'm working on. I want to input all information under the invoice form tab and then export those information accordingly to the invoice database tab. I'm looking to insert the copied information on row 3, and put any succeeding entry above that. My problem is, I have to put the cursor back on row 3 to insert a new row. I was wondering if there's anyway where it automatically inserts a new row on row 3 even if another cell is actively selected.

Any help is much appreciated.