Hi
I'm trying to come up with a solution with bring across a promotional comment from a merged cell.
On a second worksheet i'm trying to reference in the marketing comments but the joyous excel Merged cell issue means it will only bring in the comments from the first product with the merged cell next to it.
What it needs to do is bring across the same comment in this case rows 1-6, 7-11, 12-13, 15-16.
These references will change with each activity so i cant set up a static formula to do it.
The full spreadsheet as 900 lines so needs to be a quick fix than unmerging and filling down.
thanks
Adi
Bookmarks