Pass cell content into a filter

Hi all,

I am doing a simple filter list copy and paste into another worksheet and I have a challenge trying to pass the value in Cell B1 (which contains the city) as a filter parameter in the filtered list.

Is it possible for me to do something like that?

Appreciate your help in advance! I have wrapped the code of my sub below.

Cheers,
Jerry

Please Login or Register  to view this content.

With this code,

Please Login or Register  to view this content.

you are placing the contents of a variable, B1, into another variable, FilterName.

In your case B1 is a cell reference not a variable so must be treated as such.

Please Login or Register  to view this content.

You should also include a reference to the worksheet as part of that range, so change <sheetname> as appropriate.