globally adding a value across worksheets
 

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.

globally adding a value across worksheets
 

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.

"Karina M ;)" wrote:

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.

globally adding a value across worksheets
 

See your other post with 3 answers.
susan


On Oct 21, 2:18*pm, Karina M ;)
wrote:
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.

globally adding a value across worksheets
 

Check out your previous post..

If this post helps click Yes
---------------
Jacob Skaria


"Karina M ;)" wrote:

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.

globally adding a value across worksheets
 

see replies to your earlier posting.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 11:18:06 -0700, Karina M ;)
wrote:

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.

globally adding a value across worksheets
 

That was very easy. Thanks!

"Sean Timmons" wrote:

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.

"Karina M ;)" wrote:

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.

globally adding a value across worksheets
 

no problem!

"Karina M ;)" wrote:

That was very easy. Thanks!

"Sean Timmons" wrote:

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.

"Karina M ;)" wrote:

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.