Hello,
I have been working on this for over a week now and feel like I'm banging my head on the wall.
I have a report that has tons of Merged cells. This report needs to be sent to Clients so it must be formatted and look a certain way. The problem is that our reporting software does not spit out the data in a way that is pleasing to our clients. I need to unmerge cells sort then re merge the cells. I have tried numerous ways and always run into issues.
I can handle all the formatting and borders and making it look pretty. however afterIi unmerge the cells and sort from oldest to newest i can never get a macro to merge the cells back the way they should.
I think it may be possible to seperate everything with a row full of 1's
I know Merging cells with macro's is a pain and unadvised which is why I have been at this for over a week. If someone could help solve this piece of the puzzle i think i may have it finished.
Bookmarks