Code working but on wrong sheet

[pauldaddyadams]

Hi,

The code below works however it copies it to the wrong sheet (the sheet you are viewing when the macro is ran).

I think this is the part i need to amend:

Please Login or Register  to view this content.

Is there any way I can select the sheet I want to copy it to e.g.
=Range(Sheets("macro"."A1")

This is the code in full

Please Login or Register  to view this content.

[royUK]

You need to add the sheet name before that part

[pauldaddyadams]

How do I do that, I tried this but it didnt work (sheet name is Macro)

Please Login or Register  to view this content.

[Alf]

You could try:

Please Login or Register  to view this content.

Alf

[pauldaddyadams]

Unfortunatly that didnt work

[Colin Legg]

Hi Paul,

Copying to a different sheet with the advanced filter is one of the rare occasions when you have to use the Worksheet.Select method. That is, you must ensure that the target sheet is the active sheet before you call Range.AdvancedFilter.

Something like this (untested):

Please Login or Register  to view this content.

[pauldaddyadams]

Excellent - that worked!! Thank you!

I wish i never ever used advanced filter lol