Macro Copy and Pasting

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

What code are you using to facilitate this copy and paste?

An example would be helpful in aswering your question.

Christine,

Post the relevant bit of your code, then we may have a chance of working out
what's going wrong.

Henry


"Christine" <christine.rutter@lineone.net> wrote in message
news:d9f78c$32s$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> 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
>

Hi Christine,

The trick to copying filtered data to another worksheet is to run the
advanced filter from the target sheet.

For step by step instructions, srr Debra Dalgleish's web page on advanced
filters at:

http://www.contextures.com/xladvfilter01.html

Perhaps you could record a macro whilst following Debra's instructions to
provide code which you could adapt for your purposes.


---
Regards,
Norman



"Christine" <christine.rutter@lineone.net> wrote in message
news:d9f78c$32s$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
> 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
>