| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add values across 26 worksheets globally | Excel Discussion (Misc queries) | |||
| Adding Across WorkSheets | Excel Worksheet Functions | |||
| adding worksheets | Excel Discussion (Misc queries) | |||
| Globally change print settings for several worksheets at the same | Excel Discussion (Misc queries) | |||
| adding worksheets together | Excel Discussion (Misc queries) | |||
Linear Mode
