How to merge one cell from many workbooks to one cell on one work

[Marc]

I have 7 different workbooks that link back to one Master workbook. Each
workbook has a Remarks Cell. I would like to know how to merge each of the
remarks into one Remarks Cell on the Master workbook without over wrting each
one.
EX: Sales Remarks from sales Workbook
ARCH Remarks from sales Workbook
Banking Remarks from sales Workbook
List all in the same cell with marked remarks without over writing on the
master.

Please Help

Thanks

Marc

 

[Ragdyer]

First, open all the WBs.

Then, on the Master WB, format the cell that you want to contain all the
remarks as:
<Format> <Cells> <Alignment> tab,
And click on "Wrap Text", then <OK>.

Click in that cell and enter an equal sign (=),
Then navigate to the first WB and click in the cell containing the "remark",
In the formula bar you'll see that XL has entered the path to that first
"remark' cell,
NOW ... IN THE FORMULA BAR, enter:
&CHAR(10)&
Then, navigate to the second WB and click in the cell containing that
"remark",
And do the same thing, in the formula bar add,
&CHAR(10)&
And continue the same procedure until you click in the final "remark" cell
in the last WB,
Then just hit <Enter>.

Make sure the "remark" cell on your master WB is wide enough and high enough
to display all your remarks.

 

[Tom Jung]

try linking all cells to a series in the target worksheet then use the
CONCATENATE command

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single
text item. The text items can be text strings, numbers, or single-cell
references.

Remarks

The "&" operator can be used instead of CONCATENATE to join text
items.

=CONCATENATE(E14," ",F14," ",G14," ",H14)