agnesz
02-26-2008, 07:08 AM
I have a file with over a hundred employee names followed by their financial results. I also have 5 columns with RANK and IF conditions which highlight who ranks number 1 and who made or beat their plan. I would like to get a macro which scans this table of names and results and creates a whole new spreadsheet with the people who meet a specific criteria. I'm attaching a version of this spreadsheet to make it easier to understand.
List #1 criteria:
- List all names and "CO1" stats from column C through column L (buyer names and results) who rank 1 in column CT, rank 1 in column CU, have an X in columns CV, CW, and CX
List #2 criteria:
- List all names and "CO1" stats from column C through column L (buyer names and results) who have an X in columns CV and CW
List #3 criteria:
- List names and "CO1" stats from column C through column L (buyer names and results) who have an X in column CX
List #4 criteria:
- List names and "CO1" stats from column C through column L (buyer names and results) who have an X in column CV
List #1 criteria:
- List all names and "CO1" stats from column C through column L (buyer names and results) who rank 1 in column CT, rank 1 in column CU, have an X in columns CV, CW, and CX
List #2 criteria:
- List all names and "CO1" stats from column C through column L (buyer names and results) who have an X in columns CV and CW
List #3 criteria:
- List names and "CO1" stats from column C through column L (buyer names and results) who have an X in column CX
List #4 criteria:
- List names and "CO1" stats from column C through column L (buyer names and results) who have an X in column CV