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
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks