VBA code for adding specific rows based on conditions

Latteeeee

New Member
Joined
Jan 9, 2023
Messages
10
Office Version
  1. 365
Platform
  1. Windows
So, I need the code that automatically adds rows at the bottom of column H & I when rows under column A to F has additional entries.
I have a query that populates new data into the Left table, and I want the Right table to have the same rows as the Left one so I can key in additional information and such.
Reason why I'm stuck with this "two tables" is because I want a drop down list under Col H and each time query updates the table, it forces the latest entry for H move down into the latest row if its within the same table which is what I do not want, nor have I found a solution for.
In short,
1. When new rows are added to Left Table, Right Table adds additional rows to match Left Table
2. Example of data in used are two different tables with ColG hidden because the drop down list will not stop moving down when new data are entered.
3. This is after multiple attempts to find a way to stop the drop down list data from being touched.



Book1
ABCDEFHI
1Column1Column2Column3Column4Column5Column6StatusTime
2Hub/AccountIDNameActivitiesTopicFeedback/comments
3CovanteeeestteeeestInboundWorkplaceteeeest
4Covan1teeeest123teeeest12OutboundWorkplaceteeeest123
5Covan2teeeest321teeeest21OutboundWorkplaceteeeest321Yes
Sheet1
Cells with Data Validation
CellAllowCriteria
H2:H5ListYes, No
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,215,467
Messages
6,124,984
Members
449,201
Latest member
Lunzwe73

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top