filter

[matt wolfe chazin]

i have an excel master file that i need to filter by partner and then save
as a file

i repeat this process about 100 times for each partner that i want to filter

how can i automate this process?

 

[FloMM2]

Matt,
Try recording a macro. Use the "Help" in excel.
Basically you do all the work while excel writes the macro for you.
Good luck.