Crazy Dazz
New Member
- Joined
- Dec 11, 2017
- Messages
- 5
I'd like to learn more about automatically making changes to tables using VBA.
So, a specific issue I am currently dealing with:
I have multiple Tables that are manually populated with data by users as required. The tables have Suppliers as Column Headings, and a Description of Goods or services etc in the first column. (And the users populate the tables with prices.)
Suppliers are controlled elsewhere by a master list, but the data is available in these workbooks (via queries) and will auto-update.
Currently, when we add a supplier, I have to go into each workbook and each table, and manually add a column.
I tried to have the tables update using a Power Query, and it worked as far as adding the new supplier to a column header. But unfortunately the manually entered prices were then displaced into the wrong columns.
So, a specific issue I am currently dealing with:
I have multiple Tables that are manually populated with data by users as required. The tables have Suppliers as Column Headings, and a Description of Goods or services etc in the first column. (And the users populate the tables with prices.)
Suppliers are controlled elsewhere by a master list, but the data is available in these workbooks (via queries) and will auto-update.
Currently, when we add a supplier, I have to go into each workbook and each table, and manually add a column.
I tried to have the tables update using a Power Query, and it worked as far as adding the new supplier to a column header. But unfortunately the manually entered prices were then displaced into the wrong columns.
