Apr 12 2022 06:18 AM - edited Apr 16 2022 02:47 PM
i used excel for my monthly expenses since 2016 so I have a lot of monthly charts spread 32 rows deep and 6 columns wide. ( Version 2203 Build 16.0.15028 32 bit office 10)
If I opened up or sat with the cursor on a 'named item' such as groceries ( for the month of. Ap[ril 2022 .) each previous month, of course, a different dollar value generated in the column before.
Therefore column 5 -$512.07 column six reads groceries next to it,, and of course all of the column across 5 / 32 down deep then a grand figure in dollars at the bottom of Column 5.
What I like to do is to somehow highlight groceries/ amount and find all then generate a separate Chart Title to see the growth over a twelve-month/24 mon /36 month period of the months past since 2016.
I don't know that much about Excel and its hidden mysteries if any .. it would be a lot faster than manually typing in all the found information into a new spreadsheet.
Ideas??
thankyou!
Apr 16 2022 02:49 PM
Apr 16 2022 03:03 PM
It might help if you made a sample workbook (not the full one!) without sensitive data available through OneDrive, Google Drive, Dropbox or similar, and described your request in more detail using that sample.
Apr 24 2022 04:04 AM