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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add values across 26 worksheets globally 3
Copy a Formula in a Macro 3
@Sum Conditional Values within a Macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to copy & paste-special-values data to selected worksheets 1
MAX across worksheet, return text value 8
vlookup or match function across worksheets ? 5
Summing VLookup from a variable number of sheets 4

Back
Top