Enter on value in one worksheet display in whole workbook
 

I am trying to enter a new value in cell A1 and would like it displayed in
the whole workbook ( I have 12 sheets)

Thanks.

Enter on value in one worksheet display in whole workbook
 

One way,

Hold down the control key and click each sheet tab in turn i.e.select all
sheets. Enter your value in a1 and it will be in all sheets.

Mike

"ED" wrote:

I am trying to enter a new value in cell A1 and would like it displayed in
the whole workbook ( I have 12 sheets)

Thanks.

Enter on value in one worksheet display in whole workbook
 

Or hold down shift and click first and last tab

--
Regards,

Peo Sjoblom



"Mike H" wrote in message
...
One way,

Hold down the control key and click each sheet tab in turn i.e.select all
sheets. Enter your value in a1 and it will be in all sheets.

Mike

"ED" wrote:

I am trying to enter a new value in cell A1 and would like it displayed
in
the whole workbook ( I have 12 sheets)

Thanks.

Enter on value in one worksheet display in whole workbook
 

absolutely correct, blonde moment from me ;)

Mike

"Peo Sjoblom" wrote:

Or hold down shift and click first and last tab

--
Regards,

Peo Sjoblom



"Mike H" wrote in message
...
One way,

Hold down the control key and click each sheet tab in turn i.e.select all
sheets. Enter your value in a1 and it will be in all sheets.

Mike

"ED" wrote:

I am trying to enter a new value in cell A1 and would like it displayed
in
the whole workbook ( I have 12 sheets)

Thanks.