How 2 change date in 1 cell/worksheet so it changes in all workshe

[Mjd0985]

I work with an excell workbook to print labels for medication dispensing. We
used to have it set up that when you changed the fill dates and the
dispensing dates in our first worksheet, it changed all those same dates on
each of our over 50 worksheets with patient labeling. At some point this go
messed up and it no longer works. I have to manually go in and change these
dates on each of our sheets in the workbook! It is very time consuming. Can
you please tell me how to link these cells throughout the whole workbook so I
don't have to do this each week! Thank you!

 

[Luke M]

Select all of the other 50 sheets (Use Shift to select array of sheets). With
all sheets selected, select the cell you want to reference to link. Input
something like this:
='Main Sheet'A2
Copy formula down/across as needed

All of your 50 sheets will now have the same formula(s) in the same cell(s).

 

[Gord Dibben]

Select Sheet1

Enter a date in A1.

Select Sheet2 then SHIFT + Click on Sheet50

In A1 of Sheet2 enter =Sheet1!A1

Ungroup the sheets.


Gord Dibben MS Excel MVP