Automatically populating/removing rows in a table based on the values of another table

ExcelNoob75

New Member
Joined
Dec 10, 2019
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hello,

I'm very new to this forum, just created an account because I've been googling for hours and I can't find a solution to my problem. Hope someone here will be able to help me.

I have a 1st table, called "IDStatusSettings" in Sheet 1:

IDStatusSettings.PNG


This table is displaying datas from other sheets in my document. As you can see there's lot of rows with a 0 as an ID. The value of these cells will become an ID if modifications are made in some other sheets (I'm not being too specific because it's not directly linked to my questions, it is just for you to understand why I'm doing this). My issue is that this table is meant to be manipulated by its user (filtered, sorted) but because of the way its built, the smallest modification you make to it absolutely destroys the table, and every data becomes completely wrong. Plus with all the rows with a 0 as an ID, it can't be sorted efficiently. I've shorten the list for the screenshot but imagine it having hundreds of rows.

So my aim here is basically to get this IDStatusSettings table to automatically populate the rows of an IDStatusDisplay in Sheet 2, in order to have another version of my initial table, but a version without the 0 rows to be cleaner, and that can be sorted without breaking the datas.

The things that makes it hard for me is the automating part. I would need the IDStatusDisplay to automatically add a row when a 0 turns into an ID in the first table (with the correct ID and the value of the cells in the other columns of the row), and to automatically remove it if an ID turns to a 0.

I tried to make a visual representation of I'm trying to achieve, hope it helps.

IDtableaux.PNG


What I would like to see happening when modifications are made in the first table:

IDmodifs.PNG




Is it possible to do such a thing using VBA?

Please feel free to let me know if my post is not complete enough for you to help, or if I'm not respecting any of the rules of the forum. I'm not getting into details about the datas in IDStatusSetting because I think it would only make my question even foggier, but I can.

Thanks in advance.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

ExcelNoob75

New Member
Joined
Dec 10, 2019
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Sorry for that but the last image is wrong, please use this one instead:

(can't find a way to modify my original post, can someone please tell me?)


IDmodifs.PNG
 

ExcelNoob75

New Member
Joined
Dec 10, 2019
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Help please? If it is not possible can someone please tell me so I can stop bothering myself for nothing? :)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,362
Messages
5,547,473
Members
410,797
Latest member
mlfuson
Top