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.
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 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | H | I | ||||
1 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Status | Time | |||
2 | Hub/Account | ID | Name | Activities | Topic | Feedback/comments | |||||
3 | Covan | teeeest | teeeest | Inbound | Workplace | teeeest | |||||
4 | Covan1 | teeeest123 | teeeest12 | Outbound | Workplace | teeeest123 | |||||
5 | Covan2 | teeeest321 | teeeest21 | Outbound | Workplace | teeeest321 | Yes | ||||
Sheet1 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
H2:H5 | List | Yes, No |