| Home |
| Search |
| Today's Posts |
|
#1
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Linear Mode
