Link three or more cells across spreasheets

Hello everyone!

I'd like to apologise if this issue has already been discussed previously, but despite searching high and low on Google and on this forum, I couldn't find any answer for my problem.

What I am trying to do is as follow:

I'd like to get a cell that displays the same value across all sheets, so that if I put a value in - for example - D3 in Sheet1, it'll display the same value in D3 in Sheet2 et Sheet3, but if I edit D3 in Sheet2, it'll also change the value of D3 in Sheet1 and Sheet3, and so on.

(Basically, some people and I have to manage an inventory where products are separated in different sheets, and I'd like them to be able to put the last time they changed something in the inventory, i.e "Last edited on 5/17/14". And I'd like this date to be displayed on all the sheets, without having to edit the "last time edited" date on all the sheets, nor having to go back to Sheet1 to see the date).

I'm quite the newbie at Excel, I tried some things, but I really don't know what tool I should use to do this.


Thanks a ton in advance for helping me out!

A-Z

Thanks for the very quick answer!

However, I tried that solution before. If I edit A1 on Sheet1, the value is correctly repeated on Sheet2 and Sheet3, but if I edit A1 on Sheet2 or Sheet3, it doesn't affect the other sheets, so it doesn't really fix my issue.

What I'd need is for A1 to be a constant cell across all sheets, no matter what sheet I edit A1 from.

Thanks again for helping me!

I followed your steps carefully, but that doesn't seem to work. Is the fact that I renamed the sheets' names bothersome for the code (Though I did try to replace all the "Sheet1", "Sheet2" and so on with their respective custom name)? Do I really have to simply close Excel and then open the file again for the changes to take effect? I did everything you wrote.

Thank you once again.

How do I have to use that code? I must be doing something wrong: I enter a date in A1 on Sheet1 (The A1 cells being empty on Sheet2 and Sheet3), I save and close the file, but when I re-open it, the A1 cells on Sheet2 and Sheet3 are still empty.

Is there any step I missed?

Thanks a ton, that works great! The only issue I'm having is that all the A1 cells have to be empty first: It works perfectly fine the first time, but when I re-open the file, edit the date in one of the A1 cells and close it again, it goes back to the previous date, the one in the other 2 A1 cells. Is it supposed to do this or did I fail something when copy/pasting?

Wait, I'm sorry, I understood the code only now: It detects the highest value between the 3 cells and then it applies the highest in the other cells, which makes sense for a "last edited" date! It wasn't working because I was testing with random dates, but now that I understood, it works perfectly!

I only got 2 questions:
- Is there a way to make the change more instantaneous? So that people don't have to wait until they have to close the file for the changes to be made?
- And would it be possible to adapt the code to create another cell "Last edited by <name of the person>", based on the same principle as "Last edited on <date>" (Changing one cell - let's say B1 this time - in one sheet changes B1 in the other sheets)?

Wow, that works super fine, you're amazing! I don't think I could thank you enough!