I'm trying to modify a macro so it will run in each worksheet, instead
of making one for each sheet.
The macro copies some data from the previous sheet (each month of the
year has it's own sheet but the order may get changed). So I want to
program the macro to read the current active worksheet name and based
on that go to the previous month.
I've found you can get the name by entering worksheet(number).name,
but then the problem just shifts to getting the current worksheet number.
Which command can I used to solve my problem?