vbanewbie365
New Member
- Joined
- Feb 26, 2023
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
Hi all,
I've got a large data table 'Merged Data' (itself pulled from individual data collection sheets via a macro) and want to perform some clean up and housekeeping to make it more readable.
The first task is rearranging columns so there are 'groups' of columns that are similar in nature. In the attached workbook, this would look like the sheet 'Read Table' which I've just manually pasted together. Ideally the VBA code would be based on the header names rather than cell position as I think this will change over time, so I would like the ability to change things in the code easily to adjust to evolving requirements.
Secondly, I want to create 4 new columns which are more general in nature than what is currently in 'Merged Data'. My first new column would be called 'ID 1', which merges data from the current 'Transmission type' and 'Model type' columns from the 'Merged Data' sheet. So the line items would remain the same, but if the line contains data from either 'transmission type' or 'model type', the data in that cell would now sit in the new 'ID 1' column. 'ID 2' would simply be 'Identifier'. 'ID 3' would simply be Transaction type'.
Appreciate any help I can get!
I've got a large data table 'Merged Data' (itself pulled from individual data collection sheets via a macro) and want to perform some clean up and housekeeping to make it more readable.
The first task is rearranging columns so there are 'groups' of columns that are similar in nature. In the attached workbook, this would look like the sheet 'Read Table' which I've just manually pasted together. Ideally the VBA code would be based on the header names rather than cell position as I think this will change over time, so I would like the ability to change things in the code easily to adjust to evolving requirements.
Secondly, I want to create 4 new columns which are more general in nature than what is currently in 'Merged Data'. My first new column would be called 'ID 1', which merges data from the current 'Transmission type' and 'Model type' columns from the 'Merged Data' sheet. So the line items would remain the same, but if the line contains data from either 'transmission type' or 'model type', the data in that cell would now sit in the new 'ID 1' column. 'ID 2' would simply be 'Identifier'. 'ID 3' would simply be Transaction type'.
Appreciate any help I can get!