I dont think this is possible because of circular references but I figured I would ask.
Is it possible for Cell A1 on Sheet1 to always match Cell A1 on Sheet2 no matter which cell I change?
I dont think this is possible because of circular references but I figured I would ask.
Is it possible for Cell A1 on Sheet1 to always match Cell A1 on Sheet2 no matter which cell I change?
Place this formula in A1 of Sheet1: =Sheet2!A1
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks for that, however, it won't work because I need to be able to change either cell any give time. If I change A1 Sheet1 then that change needs to show up in A1 Sheet2. If I change A1 Sheet2 then that change needs to show up in A1 Sheet1.
With a macro yes. You would likely have to do 2 routines, 1 for each sheets change event in which you would:
- Check that the change was for the desired cell(s) only
- Set the other cell on the other sheet to the same value
Place this macro in the worksheet code module for Sheet1:
Place this macro in the worksheet code module for Sheet2:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks! I got a error:
Run-time error '28':
Out of stack space
I tried it on a sample file and it worked properly. It would be easier to help if I could test it on your file. Can you attach a copy?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks