Variable as the filter condition

[Sgligori]

Good afternoon!

I've attached a sample document to support my question.

How can I change my autofilter code in order to filter for a variable? I essentially want it to loop through all of the customers on the "Reference" tab, filtering for the customer in Sheet 1 and pasting the selection in a new tab.

[Richard Buttrey]

Hi,

Why not keep things simple, more efficient and arguably much more useful and apply a Pivot Table to your data and use the PT to analyse your data - using PT Slicers if you want a really wizzzy presentation.

Of course you could have a macro create new sheets for every customer but why duplicate all your data?

[Sgligori]

Hi Richard, This loop criteria is part of a much larger code.

I need to determine the answer to my initial question in order to get all of my files in working order.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

I can't see any AutofilterCode!

[Sgligori]

Perfect! Thank you, John!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.