enter text in cell and have value change in all worksheets; with l

U

ursobutfo2me

Hi,

I have a workbook with 20 worksheets. I would like to set up the worksheets
so that if I change a value in a cell in any worksheet, the same cell will
change to the new value in all the other worksheets.

To make matters more complicated, the value within each cell is selected
from a drop-down list that I have already created.

Any help would be appreciated! Thanks!
 
P

paul

you can do what you want but not from ANY worksheet.You can change all cells
on all other worksheets from only one worksheet
 
J

John James

Say the cell that holds the drop-down list value is cell A1 on sheet 1.

Then on sheet 2 enter:
=Sheet1!A1

Copy and paste this formula to cell A1 on all other sheets (sheet 3 to
sheet 20).
 
B

Bryan Hessey

I believe it is possible under VBA to setup an Event code that will
detect a change within a range, copy the .value from the active cell,
and paste that to the same cell on all 20 worksheets (including the
current). This code could then be copied to (and would apply to) all 20
sheets, but performance might not be great.

Is this what you would want?

--
 
Top