Please help.

I am trying to create some macros in Excel 2003. I am filtering some data on
one sheet, copying the filtered data to a new sheet and then doing some
calculations on a 3rd sheet which relates to the data on the 2nd sheet.

However having created a created which worked when I created it, I re-run it
to check it and the data isn't transfered. I get a blank 2nd sheet, which
then means that I can't do the calculations.

What am I doing wrong? I'm sure that on previous versions of excel this has
worked ok.

Please help.

Thanks.

Christine