VBA filter ?
 

So I am trying to create a macro that filters a list and paste the filtered
results into different tabs for certain groups I am filtering. Some months
include all the available stores and others only include a portion of
them...so if I am running this on a month that doesn't include Store A, then
the macro stops running when it looks for Store A in my list. I want this to
be a template that I can use each month so I would like it to account for
this variability...any thoughts? Please ask any questions you think would
help you answer this question. Thanks.

VBA filter ?
 

Post your code pointing out the line were it stops...
--
HTH...

Jim Thomlinson


"Mike" wrote:

So I am trying to create a macro that filters a list and paste the filtered
results into different tabs for certain groups I am filtering. Some months
include all the available stores and others only include a portion of
them...so if I am running this on a month that doesn't include Store A, then
the macro stops running when it looks for Store A in my list. I want this to
be a template that I can use each month so I would like it to account for
this variability...any thoughts? Please ask any questions you think would
help you answer this question. Thanks.