szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
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.
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.