View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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.