Run AdvancedFilter multiple times and show output on other sheet

I have successful AdvancedFilter code running on one sheet. By changing cell B1 I am automatically filtering records by date, which allows for a historic calculation of this loan portfolio. Cells D1:J1 are calculated results and will change as B1 is updated.

Annotation 2020-09-09 153153.png

My goal is to chart D1:J1 by month. I need to update B1 automatically a given number of times and put the results into a simple sheet like the one below. Right now I am just running each month and pasting the results. It gave me the charts I need but this is a real pain if the source data changes!

Where do I even begin?

Annotation 2020-09-09 152938.png

Guidance to the right code or help files would be greatly appreciated!

We can create a custom file to create the data you want through the use of VBA, but we need the underlying file to carry out the work. Please follow the instructions in the yellow banner above to upload a working file.

Thanks, I was hoping not to actually upload the file or have someone do the work for me. Rather I'd like a pointer in the right direction. If you think it's critical I can spend some time tomorrow sanitizing the file - lots of sensitive data.

I did it! And yes I basically went and re-learned loops, I was so very rusty, I managed to get this together in about 2 hours, not too shabby. Ready for the next challenge.
Should anyone else need this it's not unlike running a Vlookup multiple times

Please Login or Register  to view this content.