View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Karina M ) Karina M ) is offline
external usenet poster
 
Posts: 3
Default 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.