creating a macros and repeating it

  • Thread starter Thread starter fvs
  • Start date Start date
F

fvs

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?
 
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
 
You must log in or register to reply here.

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

GPS Coordinates 3
Copying filtered four cells by means of macro 4
macro using cell value 4
Access Macro Repeat Expression using value of a field in table 0
repeating macro 2
VBA - retrieve data on last create named range from previous inserted named range 0
@Sum Conditional Values within a Macro 1
multiple functions on one cell ? 6

Back
Top