 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Control a variable from multiple cells
I have an excel workbook with multiple worksheets. How do I create a cell on each of the pages such that if I change it on any one sheet, I will get that value in the cell I want on each individual worksheet? If that's not clear, let's say on sheet 1 I want A1 to be tied to A2 on sheet 2. If I change sheet1 A1 I want sheet2 A2 to change to the same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to take the same value. That is a circular reference. In this case it cannot be resolved. If you change A1 on sheet1, A2 on sheet2 changes to it (a1 on sheet1) and sheet1, A1 then changes to sheet2, A2 which then changes to sheet1, A1 which then changes to sheet2,.A2 which then changes to sheet1, A1 which then changes to sheet2, A2, .......etc, Get the idea? Round and round we go. Where does it stop? >I have an excel workbook with multiple worksheets. How do I create a > cell on each of the pages such that if I change it on any one sheet, I [quoted text clipped - 4 lines] > same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to > take the same value. Ross, Two possibilities. First, put the value in one cell only, like Sheet1 A1, and have the others linked to it. In other cells, you would have: ='Sheet1'!A1 You would change only Sheet1 A1. The links (formulas) must remain in the other cells. If you need to be able to change any of the cells, and have the others follow, then you need to have event macros that fire when a sheet is changed, examine which cell was changed, and if it's one of those we care about, write that value into all the other cells.  SignatureRegards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- >I have an excel workbook with multiple worksheets. How do I create a > cell on each of the pages such that if I change it on any one sheet, I [quoted text clipped - 4 lines] > same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to > take the same value. I think the point is moot. It is a circular reference. > Ross, > [quoted text clipped - 16 lines] >> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to >> take the same value. No it's not moot nor is it a circular reference SignatureRegards, Peo Sjoblom >I think the point is moot. It is a circular reference. > [quoted text clipped - 18 lines] >>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to >>> take the same value. I apologize Wondering, it was sloppy reading on my part, of course it is circular reference if one uses formulas SignatureRegards, Peo Sjoblom > No it's not moot nor is it a circular reference > [quoted text clipped - 20 lines] >>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to >>>> take the same value. Hi guys, I'm not sure why this circular reference issue has come under my post. My formula suggestion is to have all the other cells all refer to one cell, then change the data only in that one cell. There's no circular reference there. SignatureRegards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- >I apologize Wondering, it was sloppy reading on my part, of course it is circular reference >if one uses formulas [quoted text clipped - 22 lines] >>>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to >>>>> take the same value. Sorry about that Earl, I responded to a post that was responding to you but I then read the OP's first post thus I retracted it . It is definitely clear that your solution is not a circular reference so my first post should have stood SignatureRegards, Peo Sjoblom > Hi guys, > [quoted text clipped - 30 lines] >>>>>> same value. Likewise if I change A2 on sheet 2 I want sheet1 A1 to >>>>>> take the same value.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.