LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel should allow mirroring of multiple cells

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mirroring excel file content bham Excel Discussion (Misc queries) 2 April 27th 10 01:07 PM
Mirroring Data in Excel Mahurshi Akilla Excel Discussion (Misc queries) 3 September 22nd 07 05:46 PM
Mirroring observations in Excel table along diagonal Arjen Excel Discussion (Misc queries) 0 August 1st 06 02:12 PM
Excel Mirroring Data mickp Excel Worksheet Functions 1 June 21st 06 06:36 AM
Mirroring cells careyc Excel Discussion (Misc queries) 5 October 17th 05 03:49 PM


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"