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.

---

Originally Posted by RobertCo

Hello Bryan,
Thank you very much for helping me out, I will review the sheet as well as the macro. I will also respond back to your questions that I saw in the sheets.

I really do appreciate the time you put in and explaining how and what you modified. I will take the lesson and incorporate them into the changes I will make.

Once I complete the sheet I will post it back here so all can see how it was accomplished and I can contribute to this well-informed Forum.

I will be learning more about how macros work in the next few days and look forward to feedback once I put them to use.

Have safe and Happy Holidays


Nullum Gratuitum Prandium.
I will do my best to contribute!!

RobertCo

Hi Robert,

there is no reason to answer my questions except to yourself, but note that by Merging cells and Shading rows you will be setting a task for every time a new item is created.
By using Conditional format it is automatic.

Looking forward to some future posts as you progress.
---