| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a macros and repeating it
I have to replace certain values in a spreadsheet which then gives me new
calculated values. But the thing is I have to do this for 180 other worksheets. Is it possible to create a macro substituting the values and retrieving them. And then repating the process for the other 179? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating a macros and repeating it
If the certain values are the same across all 180 sheets you could loop
through the sheets with one macro. Provide some details on your data layout. Gord Dibben MS Excel MVP On Tue, 2 Dec 2008 04:31:00 -0800, fvs wrote: I have to replace certain values in a spreadsheet which then gives me new calculated values. But the thing is I have to do this for 180 other worksheets. Is it possible to create a macro substituting the values and retrieving them. And then repating the process for the other 179? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a new list of repeating data in a column | Excel Worksheet Functions | |||
| macros creating | Excel Discussion (Misc queries) | |||
| Creating Repeating Rows in Mulitple Worksheets | Excel Discussion (Misc queries) | |||
| creating repeating headers in a worksheet | Excel Discussion (Misc queries) | |||
| Macros-creating new sheets | Excel Worksheet Functions | |||
Linear Mode
