paul_sykes00
Board Regular
- Joined
- May 7, 2012
- Messages
- 53
Sheet 1 has a table of data in the rangeA2:I1000 which I wish to filter
Sheet 2, Column A has a list of filter values starting in Cell A2
“MacroX” is macro I wish to run after each loop
I'm trying to achieve the following
Loop 1
Filter “Sheet 1, Column 1” by the value in “Sheet 2, Cell A2” then run macro"X"
Loop 2
Filter “Sheet 1, Column 1” by the value in “Sheet 2, Cell A3” then run macro"X"
Loop 3
Filter “Sheet 1, Column 1” by the value in “Sheet 2, Cell A4” then run macro"X"
and so on until the macro has run through all filter values in “Sheet 2, ColumnA”
Hope you can help. Thanks in advance.