Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How to merge one cell from many workbooks to one cell on one work
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. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Marc" wrote in message ... 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 |
#3
|
|||
|
|||
How to merge one cell from many workbooks to one cell on one work
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) -- Tom Jung ------------------------------------------------------------------------ Tom Jung's Profile: http://www.excelforum.com/member.php...o&userid=28448 View this thread: http://www.excelforum.com/showthread...hreadid=480479 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
The merge center icon remains gray and does not work. | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |