View Single Post
  #1   Report Post  
Marc
 
Posts: n/a
Default How to merge one cell from many workbooks to one cell on one work

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