I would like to have a combo list box that has every day of the week in it. When i select different calendar days, i want my data set to add up the values of a 7 day period from saturday thru sunday based on the weekday that falls on the first day of the month chosen. for example if i had a data set like the one below and the first day of the month fell on a saturday, and i selected saturday in my drop down box it would start adding up and subtotaling the first seven daysto equal 3300, then the second seven ect. However if the 1st day of the month started on a thursday then i would want to add up the 1st and 2nd =600, then the 3rd - 10th=3900, then 11th -18th ect.. the macro would be tied to the weekday that i select in my drop down box.
1 400 2 200 3 300 4 100 5 600 6 800 7 900 8 1000 10 200 11 300 12 400 13 700 14 900 ....... --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---