Setting the same cell on multiple worksheets

jdvorak

New Member
Joined
Mar 4, 2010
Messages
10
I am creating a 3D worksheet and need to set the same cell on multiple worksheets at the same time.

As a user enters text in a cell, say ("C4") on one worksheet, the same cell ("C4") on several other worksheets are updated with the user's input. Does anyone know how to do this? Thanks in advance.

Joe
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Hold down the SHIFT key and click the worksheet tabs to select multiple worksheets. (The word "[Group]" will appear after the filename in the title bar.) Once in group mode, any change in a cell is replicated to all the cells in that group of worksheets.

If you need to pick and choose worksheets, use the CTRL key instead of the SHIFT key and click the worksheet tabs one at a time.
 

jdvorak

New Member
Joined
Mar 4, 2010
Messages
10
Thanks Greg for the quick reply. However, I was interested in doing this using VBA macros. So that it happens automatically as the user enters the text.

Joe
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Take a look at the FillAcrossSheets method for sheet/worksheet objects and play with that a bit. Post back if you get stumped. :wink:
 

Watch MrExcel Video

Forum statistics

Threads
1,122,310
Messages
5,595,412
Members
413,990
Latest member
Kher83

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top