Replicate dates

I have a workbook with ten sheets. The front sheet is a summary with nine divisional data sheets (DDS) following. In every sheet cell G12 has the date. At the moment the DDS reference the summary sheet and pick up the same date from it. Is it possible to set it up so that if I change the date in cell G12 on any of the sheets I can get them to all read the same?

Hi Bob,

This code may work for you. Add it to the ThisWorkbook module. It checks for incorrect data being entered (e.g. non-date value) and handles it by telling the user they've entered incorrect data and then un-doing that last entry.

Please Login or Register  to view this content.

Hope that helps!

You know how to do it on one sheet and use simple cross references on the other sheets, right?

=Sheet1!G19

Put that into the other 9 sheets and they will automatically change when you change sheet1.

Now, I know you want to be able to change it from any sheet, so in the Worksheet Module for the other 9 sheets, put this macro:

Please Login or Register  to view this content.

If you type a date into THOSE sheets, it will move that value to sheet1 and put the formula back into the cell you typed in.

Sorry, cleaned up the code a little, forgot to turn off the AppEvents:

Please Login or Register  to view this content.

Hehe, I gave you the code, I even put it in the first couple of sheets. Now you need to put it in the rest of the sheets you want it active in.

Also, I put it in Sheet1 and it should NOT be there, so be sure to take it out.

Alt-F11 to open the Editor...

Originally Posted by BRISBANEBOB

Paul

How would I restrict the use of your code to a number of sheets, but not all?

Thanks

This is why I used the worksheet_ change so you could simply add it into the sheets you want it active in.

Alt-F11
Double-click Sheet2 and paste in the code, close the small window
Double-click Sheet3 and paste in the code, close the small window...
Repeat only on the sheets you want the code to work in.

My code watches cell G19, if it changes, it memorizes the change, puts the formula =Sheet1!G19 back into the cell so it is getting its value from the main sheet again, the puts the value it memorized INTO Sheet1!G19 making all sheets update.

Please Login or Register  to view this content.

I commented the code in #10 if you want to use that version, just an option.

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]