• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

filter according to months

C

crossettman

New Member
I have a spreadsheet that has records of mileage that I drive for work. Col. A - Date Col. B - From City Col C - To City Col D - Beginning Odometer Col E - Ending Odometer Col F - Total Mileage (Col e - Col d) I want to use VBA that when I click a button it will subtotal the sheet by the months. The sheet will have daily entries on it. It may have 2- 25 entries for 1 day and the same for each day of the month. I can get it to subtotal by the day, but I want it to subtotal by the month. (List each record of the same month and subtotal that month, skip a line and do the next month the same way)

I also have a drop down list of months. I want to choose a month (such as July) and have VBA to copy all the records of that particular month on another sheet and give me a total mileage for that month.


Thank you,

Don (crossettman)
 
@Crossettman


Hi


Welcome to Chandoo.org Forum, Glad you are here


please check the below link may be it will help / give some idea to you


http://chandoo.org/wp/2012/11/27/extract-subset-of-data/


Hope with the above link your problem solve other wise inform us with a sample workbook

to attach a sample workbook please folow the below link


http://chandoo.org/forums/topic/posting-a-sample-workbook


Thanks


SP
 
You must log in or register to reply here.
Back
Top