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

szakharov7723

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

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
If you still need help, I can look at it middle of next week. Let me know
 
Upvote 0
Yes please.
The idea behind this is to find keywords (from table-list) and do future manipulations with data containing them (queried raw data)
 
Upvote 0
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)?
 
Upvote 0

Forum statistics

Threads
1,223,948
Messages
6,175,579
Members
452,652
Latest member
eduedu

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