Merge multiple rows with <alt-Enter> intact

Originally Posted by RobertCo

Hello Bryan, Thank you for the reply and willingness to assist.
What I have is a Generic Status reporting workbook that I am trying to have automatic updating and conditional formatting done so when I run tests I can quickly review what is needed and what is completed.

I have attached a smaller version (genericStatus.zip) which will give you an idea of what I am trying to accomplish.

I have been working with the report now for about a day and think that I have a good idea as to where I want to take it going forward.

If you have some additional Ideas as to how I should arrange data or sheets please feel free to let me know as I am not restricted by making changes.

I have added notes to the bottoms of the columns with what I would like to do
Some of the things are complete but you will be able to see where I am having problems with the automation due to merged cells etc

I again thank you for your help and Once I get a final version I will be glad to contribute it here.

ok,

for a test, try the attached.

---