Hey guys,
Was wondering if I could get some help on this one. I'm looking to create an auto-updating Excel file for a full year (hopefully has the ability to do multi-year as well) for each month that is in Calendar form. Basically its pulling in the information to the right and populating it into the Excel on the right. I'm not an Excel expert, so I can't seem to figure out how to get Excel to return multiple data for one lookup source.
I'm hoping to create one where I can potentially toggle the month / year or even one with the ability to switch between two months (for example Jan + Feb or Aug + Sept) would be good as well.
Appreciate all the help!
[ATTACH]415850
Bookmarks