Merge multiple rows with <alt-Enter> intact

Originally Posted by RobertCo

Hello Everyone,

I am not sure how to go about this task and thought I would ask here.

What I have is multiple sheets within a workbook.

to simplify I will break the data down here

Tasksheet has 3 colums with many rows

Column A = ID
Column B = Steps
Column C = Task

Column A has merged Cells ( for rows)
IE
A[1=4] = ID01
Column B1 = 1
Column B2 = 2
Column B3 = 3
Column B4 = 4

Column C1 = Step 1
Column C2 = Step 2
Column C3 = Step 3
Column C4 = Step 4
----------------------------
In another Worksheet called Summary
I have 3 Columns
Column A = Steps
Column B = Actions
Column C = Comments

I have tried to use the following formula =Tasksheet!C2&Tasksheet!C3 to combine the rows into a Single Row, but when I do this it strings the data as a single line
resulting in a row with the following data B1=Step1Step2
What I would prefer is
B1=Step 1 <alt-enter>
Step 2

Secondly I merged the data in columns A1-A4 on the Tasksheet with Alt-Enter and then tried to just copy that cell but it does not preserve the cells formatting. (ie) the alt enter does not copy to the Summary sheet but an Ascii Character like a small box appears between the two lines of data.

Any help with this would be much appreciated.

Have a safe and happy holidays all

RobertCO

Hi,

this can be done, do you have a small test workbook as a sample (if I setup data it will be unrealistic, as per the attachment)

Cheers
---

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.
---