Running a report at work, which I have put through a dummy version in the images, along with what I would like the finished product to look like. (Image 1 before, Image 2 finished product)
The full report is much larger than this, so I would like a Macro to automate the process. Basically I need the Notes column (H), to merge with the above cell if Column A-F in that row is empty.
For example, A3-F3 is empty, so I need H3 to merge with H2. Similarly, A6-F6 & A7-F7 are empty, so I need both H6 & H7 to merge with H5.
Can anyone help with this?
Bookmarks