Need to understand if I need loop or something else to have DB react on input action

[szakharov7723]

So I have a certain table-list, which will have data populated or deleted sometimes.
I also have queried raw data. I want it to add 1 more column when 1 more record gets added to table-list and delete 1 column if 1 record from table-list gets deleted (it doesn't have to be certain place where column gets added or deleted, as long as it is within this queried table)
I am not sure what macro to apply in this situation ?
In general logic I see it is something like:

For every i new record in table-list
Add 1 column in raw_data_table

For every deleted record i-1 ? in table-list
Delete 1 column in raw_data_table

I can't figure out what code is applicable to this situation, I know VBA and general coding on a very basic level.

 

[sijpie]

If you still need help, I can look at it middle of next week. Let me know

 

[szakharov7723]

Yes please.
The idea behind this is to find keywords (from table-list) and do future manipulations with data containing them (queried raw data)

 

[sijpie]

I thought I put a question in earlier, but it seems not to have been done.

1. You have your table list, say on Sheet1.
- What is the layout of this list?
- When you talk about adding (or deleting) a record from the table, is that adding or removing a row, or just one cell?

2. You also have raw data, say on Sheet2. You talk about adding or removing a column.
- Does this mean your raw data is organised by column?
- How do I know what information to add to the raw data? (or which column to delete)?