Combining a group of cells in 1 worksheet into a single cell in another sheet

[plantagenet]

Hi, I am struggling to find a simple way of combining a list of components in multiple adjacent cells on one sheet into a description cell on another sheet.
I am using a text box as an intermediary but I am sure there must be an easier way that could if at all possible be automated. I have attached an example, on a single worksheet for ease of reference. As suggested in another forum Concatenate would work on a single sheet but not over two sheets. I am using Excel 2013 in W10 Thanks for any suggestions.

[BadlySpelledBuoy]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...ngle-cell.html

Thread Closed.

[plantagenet]

Well that was wonderfully helpful! If you had taken the time to read the other thread you will have noticed that the response was that I need VBA help. I checked similar threads in this forum and none fitted what I need. But if it's too much trouble for you I'll find somewhere else to get assistance! Thanks for nothing!!

[BadlySpelledBuoy]

And perhaps if you'd taken the time to read the forum rules when you signed up you'd have seen this.

5. Don't duplicate threads. If you have posted the question in one forum, do not post it again in another forum. You are duplicating efforts. If you feel the thread is in the wrong forum and needs to be moved to another forum, PM a mod / admin to do it for you.

BSB