globally adding a value across worksheets

  • Thread starter Thread starter Karina M ;)
  • Start date Start date
K

Karina M ;)

Hi:
I have 26 worksheets that I want to update with recurring values in a few
empty cells. Can I somehow use the cell name (C5) with the find/replace
option? I'm not familiar with macros or programming so please give me a
novice level solution.
Thanks.
 
just highlight all the tabs (Click on first one, hold down SHIFT and click on
the last one), then go to the desired cells and perform your find/replaces.
They will be updated on all tabs at once.
 
That was very easy. Thanks!

Sean Timmons said:
just highlight all the tabs (Click on first one, hold down SHIFT and click on
the last one), then go to the desired cells and perform your find/replaces.
They will be updated on all tabs at once.
Click to expand...
 
Back
Top