Solved

Excel: Can you link cells bidirectionally?

Posted on 2015-02-06
5
68 Views
Last Modified: 2016-02-11
As we all know, in Excel you can enter data into one cell and then within another cell refer to that cell so that the contents of cell 1 is automatically displayed in cell 2 and cell 2 automatically updates when you modify cell 1.

Can that be set up to work both ways?  I have a data field on Sheet 1 (cell 1) that I refer to in Sheet 2 (cell 2).  However, not only do I want to have cell 2 automatically update when cell 1 is changed, I want cell 1 to automatically change if I modify cell 2.

I guess the behavior I am looking for would be similar to linked Word headers, where whether you change the header in Section 1 or change it in Section 2, the same contents is automatically displayed in both.

Is that possible?
0
Comment
Question by:Dave Kong
  • 2
  • 2
5 Comments
 
LVL 35

Expert Comment

by:Kimputer
ID: 40594968
That kinda doesn't make any sense. Unless you explain in great detail what the content should be (and probably we'll have to find a different solution). Right now, your simple suggestion would lead to a circular reference which won't work. Your solution would probably involve vba and a global variable.
0
 

Author Comment

by:Dave Kong
ID: 40594986
It is a work slip from.  I have the main page for basic information with a field for the job requestor's name.  I have a separate page for specific information if the job involves, for example, printing.  If you fill in the requestor name I  can have that shown on the printing page.  However, one of my users wants to go immediately to the printing page when needed and fill in all the needed information on that sheet.  Being able to reflect that info back on the first page would make it a bit quicker to review.

I had discussed it with our Excel expert here.  Our initial thought was yours - that it would lead to a circular reference.  So no, I don't think it is possible either, but had to check in case one of the brilliant minds on this site knew something we don't.

Thanks.
0
 
LVL 20

Expert Comment

by:jmcg
ID: 40595110
I'm not expert enough to give precise details, but you could set up a Worksheet_Change event that would run when either cell is updated; the macro would then be able to change the other cell.

For an example, perhaps this link would help:

http://stackoverflow.com/questions/409434/automatically-execute-an-excel-macro-on-a-cell-change

There's probably an example somewhere here on ExpEx, but this is the one that came up first.
0
 
LVL 20

Accepted Solution

by:
jmcg earned 500 total points
ID: 40595179
0
 

Author Closing Comment

by:Dave Kong
ID: 40606281
Excellent!  I didn't think it was possible but thought someone here might know how to do it.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

0. Preface This Article is a replacement of http:/A_1788-Getting-your-EE-Ranking-statistics-in-Excel.html (http://http:/A_1788-Getting-your-EE-Ranking-statistics-in-Excel.html). Changes in the way Experts Exchange delivers point statistics, implemeā€¦
Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
Viewers will learn various types of data validation for different data types in Excel 2013.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now