This is possible. Can you send me what exactly you are doing. better would be if you could send me the file u are using
On Oct 25, 6:12 am, [EMAIL PROTECTED] wrote: > 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 -~----------~----~----~----~------~----~------~--~---
