vertically stacking the values in multiple rows into cell.

How do i vertically stack all data from a data entry userform into a cell?

I have no clue how to go about it.

Please let me know if it can be done, as i tried resizing and merging same with good result but it did not work the way i wanted it to.

Hi
Can you provide a sample so we can see what we are working with.
Thanks
Tony

HI Tony,

I've attached the file. Its just something basic I've shown how I want it to look.
Please let me know if it can be done.
I've tried merging to achieve the result, adding rows etc.
Its close ,but it tends to have lot of problems when I am working on it.

Aditi

Hi Aditi,
maybe something like

Please Login or Register  to view this content.

Hi Aditi
Just to qualify Nilem's response above this needs to be put in a macro and run. Such as:

Sub ChangeRowToColumnInSameCell()
Range("G5").Replace ",", Chr(10)
End Sub

You would need to change "G5" to incorporate all the cells you wish to change in your worksheet. For example if all the cells you wanted to change were between G1 and J100 you would change "G5" to "G1:J100".

Kind regards
Tony

aww!! thank you guys it works
here's what i tried

Please Login or Register  to view this content.

Glad we could help.
Thanks for the feedback.
Tony