JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 516
- Office Version
- 365
- Platform
- Windows
Hi All,
I am look for some suggestions on how to best handle this scenario.
In my workbook, there are many sheets, and on a daily basis the data is these sheets grows dramatically.
One of the functions I perform is to record the the subtotal of todays figures on another sheet.
Because the contibuting data is getting very deep, using the subtotal function on each sheet is doing a lot of calculation for no reason, when i am looking for one figure, todays subtotal on each of the sheets.
I don't want to delete the contributing data because it used in other areas a well.
In a nutshell, I am looking for suggestions on how to calculate the subtotal for todays date only. I see that a possability could be to use the range.subtotal property, with the range being rows that include todays date.
Thanks for the suggestions in advance.
Jeff
I am look for some suggestions on how to best handle this scenario.
In my workbook, there are many sheets, and on a daily basis the data is these sheets grows dramatically.
One of the functions I perform is to record the the subtotal of todays figures on another sheet.
Because the contibuting data is getting very deep, using the subtotal function on each sheet is doing a lot of calculation for no reason, when i am looking for one figure, todays subtotal on each of the sheets.
I don't want to delete the contributing data because it used in other areas a well.
In a nutshell, I am looking for suggestions on how to calculate the subtotal for todays date only. I see that a possability could be to use the range.subtotal property, with the range being rows that include todays date.
Thanks for the suggestions in advance.
Jeff