| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping filter criteria
Hi all, What's the code to loop through a Autofilter list. e.g John, Jack , Tim Selection.AutoFilter Field:=1, Criteria1:="John" VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Hi VBA Noob
You can create a list with advancedfilter an loop through this list See how I use it here http://www.rondebruin.nl/copy5.htm Look at this one for example http://www.rondebruin.nl/copy5.htm#all -- Regards Ron de Bruin http://www.rondebruin.nl "VBA Noob" wrote in message ... Hi all, What's the code to loop through a Autofilter list. e.g John, Jack , Tim Selection.AutoFilter Field:=1, Criteria1:="John" VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Thanks Ron.....again Happy Birthday by the way. VBA Noo -- VBA Noo ----------------------------------------------------------------------- VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383 View this thread: http://www.excelforum.com/showthread.php?threadid=57094 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Hi Ron, Can you paste both Formulas and values with advanced filter VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
No, not possible
-- Regards Ron de Bruin http://www.rondebruin.nl "VBA Noob" wrote in message ... Hi Ron, Can you paste both Formulas and values with advanced filter VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Would I be better with a Filter then How would I code say Sheet3 A2 to A29 as a array of names. e.g John Davis and then loo through all names to use as "Criteria1:" for filter. VBA Noo -- VBA Noo ----------------------------------------------------------------------- VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383 View this thread: http://www.excelforum.com/showthread.php?threadid=57094 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Hi VBA Noob
Also not working with AutoFilter You must loop through the data and copy each row that have your criteria -- Regards Ron de Bruin http://www.rondebruin.nl "VBA Noob" wrote in message ... Would I be better with a Filter then How would I code say Sheet3 A2 to A29 as a array of names. e.g John Davis and then loop through all names to use as "Criteria1:" for filter. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Ron, Instead of looping....wouldn't know where to start I was thinking I could insert a column at T to break the current region. Columns T onwards has the formulas Then use a template with my formulas to paste into. My question then is how would I adpat your code to copy the template then paste into the copy e.g Template (2) Thanks for staying with this one for me. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Looping filter criteria
Post a example for you today
-- Regards Ron de Bruin http://www.rondebruin.nl "VBA Noob" wrote in message ... Ron, Instead of looping....wouldn't know where to start I was thinking I could insert a column at T to break the current region. Columns T onwards has the formulas Then use a template with my formulas to paste into. My question then is how would I adpat your code to copy the template then paste into the copy e.g Template (2) Thanks for staying with this one for me. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570946 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter with criteria! | Excel Discussion (Misc queries) | |||
| Macro for Looping for Criteria Checking | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| Problem with basic looping and criteria | Excel Programming | |||
| multiple looping criteria | Excel Programming | |||
![VBA Noob[_42_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
