I'm working on some sales charts. The chart is broken down by day and week and by division. I need a formula that adds sales by division and keeps a running total by week in a separate area of the workbook.
I am currently having to change the formulas every week which is time consuming.
The area in orange is the section of the workbook where I need the values to be returned. Any help would be appreciated.
Please have a look at the attachment.
I've created a user defined function GetData which gets the data from the specified column (offset by 6) fron the last populated sub total row.
Hope this is what you needed.
You can see the code by hitting alt F11 and looking in Module1.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
Thanks for the response, but that's not quite what I was looking for. I need the highlighted orange section to be a running total depending on the week.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks