Let me put it another way. I want to be able to merge cells that are not
adjacent to one another....not necessarily on the same tab, or not even
necessarily on the same spreadsheet for that matter. Can it be done?
--
Doyle_D
"Doyle_D" wrote:
Not exactly. I am not looking to combine numerous cells' data.
I want to link the cells. For example, if I link cells A1 and D1, I would
be able to put a "12" in D1 and it would show up in A1. Then, I would be
able to change the "12" in A1 to a "4" in A1 and it would show up in D1. I
am talking about essentially linking two or more cells so that they behave as
though they are one cell.
If this were done with a formula, it would not work because when you started
typing data in the cell containing the formula, it would over-type and
destroy it....that is unless you can put your formula in one cell, but
designate the results of the formula to appear in another cell (without any
entry in that target cell).
Thank you.
--
Doyle_D
"Pete" wrote:
=concatenate(a1,b1,c1) Should work.
--
Pete
"Doyle_D" wrote:
I don't think this function is yet in Excel. If it is, I don't know what
it's called or where to find it.
The suggestion is simple: create a way to link two or more cells together
so that data input into any one of the linked cells shows in all the others
AND the data can be changed from ANY of the cells, with the changed data
reflecting in all the others. This would be very similar to placing an equal
sign and cell number (i.e. "=A4") in one cell to pull in data from the named
cell number. However, using a simple formula like this to link cells is only
one-way. I am looking to make it two-way, linking the cells without using a
formula so that either cell can be changed and the change reflect in the
other.
Example of use would be where you have multiple tabs in a workbook and want
to be able to input changes of key data from any of the tabs. Something like
this can already be done in Access. It would be nice to be able to do it in
Excel also.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...el.programming