Excel: Add Data to the Table after hitting the Add Record Button

**ghiegomez** · 08-19-2023, 02:51 PM

I'm new to recording Macros and I need help in writing VBA code to do the following:

I have 2 different areas in my excel. The first part is where data is being keyed and the 2nd part is the table where I want the keyed data moved over to the next available row once "Add Record" button has been clicked.

Attachment 840136 Screenshot.jpg TPE_MacroEnabled.xlsm

**protonLeah** · 08-19-2023, 05:52 PM

Please Login or Register  to view this content.

Named ranges for new record input cells:
DATA.SOURCE ='TPE Report'!$E$11
DATA.TYPE ='TPE Report'!$E$9
DateRange ='TPE Report'!$E$13
New.County ='TPE Report'!$C$13
New.FIPS ='TPE Report'!$C$9
New.State ='TPE Report'!$C$11

No reason for empty rows in the table...

**ghiegomez** · 08-19-2023, 07:38 PM

This gave me a runtime error

Set TPE_Records = TPE_Report.ListObjects.Item("table2")

Also, what do you mean by this?

Named ranges for new record input cells:
DATA.SOURCE ='TPE Report'!$E$11
DATA.TYPE ='TPE Report'!$E$9
DateRange ='TPE Report'!$E$13
New.County ='TPE Report'!$C$13
New.FIPS ='TPE Report'!$C$9
New.State ='TPE Report'!$C$11

**protonLeah** · 08-19-2023, 08:00 PM

You have a data entry form in rows 9,11 & 13. I just gave each cell a name, i.e., cell C9 is named New.FIPS., etc.
For the runtime error, is your actual table named Table2?