|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 9th, 2009, 04:52 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
November 9th, 2009, 06:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
