ChrisFoster
Active Member
- Joined
- Jun 21, 2019
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
Hi all,
I have a number of reports that are created by my CRM system. Some of the reports were built by a developer who liked to merge data across numerous columns - for instance column A:B = First Name, C:D = Surname.
Each report could have merged data across various different columns, so it's not always consistent.
The data I need is always stored in the left hand column, so where column A:B = First Name - I could just delete column B and this unmerges the cells and leaves me with the data I need but now just in one column, which would be A.
Is there any VBA code that I can use to find and delete the blank columns within a merged range? My thinking is I could maybe use code to unmerge the whole worksheet, then delete any blank columns - But I'm unsure of the best way forward. Any help would be appreciated.
Regards,
Chris
I have a number of reports that are created by my CRM system. Some of the reports were built by a developer who liked to merge data across numerous columns - for instance column A:B = First Name, C:D = Surname.
Each report could have merged data across various different columns, so it's not always consistent.
The data I need is always stored in the left hand column, so where column A:B = First Name - I could just delete column B and this unmerges the cells and leaves me with the data I need but now just in one column, which would be A.
Is there any VBA code that I can use to find and delete the blank columns within a merged range? My thinking is I could maybe use code to unmerge the whole worksheet, then delete any blank columns - But I'm unsure of the best way forward. Any help would be appreciated.
Regards,
Chris