Changin a Macro so it automatically updates the active worksheet.

[Confused Laura]

Hi

I have just recorded a macro which takes info from imported text and does
some caculations and rearranges the info onto a new worksheet. My problem is
that I need it to do the same thing over several worksheets. I have
associated the macro with a button - but need it to update that active
worksheet and not the original worksheet that I used to record the macro.

Any help would be much apreciated!

 

[Fred Smith]

Without seeing the actual code, we can't say definitively, but you probably
want to change Sheets("Name") to ActiveSheet. Also check for hard coded
workbook names.

Regards,
Fred.