I'm using this code:
=SUMPRODUCT(--('D:\Corporate\Analytics\2020Analytics\[Members2020.xlsx]Apr'!$A$3:$A$200=$B$1),'D:\Corporate\Analytics\2020Analytics\[Members2020.xlsx]Apr'!$D$3:$D$200)
which pulls information based on the tab named APR. There is a similar tab for every month. The APR tab is not populated until May, May isn't populated until June and so on. I need to modify the code above so that instead of looking at a specific predetermined tab, it looks at what the current calendar month is it will pull data from the previous month. To give it an example, right now it is September. The formula should pull from the AUG tab.
How do I do this?
Thank you in advance
=SUMPRODUCT(--('D:\Corporate\Analytics\2020Analytics\[Members2020.xlsx]Apr'!$A$3:$A$200=$B$1),'D:\Corporate\Analytics\2020Analytics\[Members2020.xlsx]Apr'!$D$3:$D$200)
which pulls information based on the tab named APR. There is a similar tab for every month. The APR tab is not populated until May, May isn't populated until June and so on. I need to modify the code above so that instead of looking at a specific predetermined tab, it looks at what the current calendar month is it will pull data from the previous month. To give it an example, right now it is September. The formula should pull from the AUG tab.
How do I do this?
Thank you in advance