Good afternoon,
I'm trying to figure out a formula that will pickup the current month data automatically but at the same time exclude the prior months data. This will be done in a seperate summary tab from the source data tab.
I should mention that this is a monthly report. So every month that I run the report I need the summary tab to pick up the current data souce that I manually enter.
I hate having to point and click the new month data within the summary tab all the time.
Any help would be greatly appriciated.
Thank you....
I'm trying to figure out a formula that will pickup the current month data automatically but at the same time exclude the prior months data. This will be done in a seperate summary tab from the source data tab.
I should mention that this is a monthly report. So every month that I run the report I need the summary tab to pick up the current data souce that I manually enter.
I hate having to point and click the new month data within the summary tab all the time.
Any help would be greatly appriciated.
Thank you....