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.

"Confused Laura" <Confused wrote in message
...
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!