Hi all, please note the extent of my Excel abilities was prior to version 5 and I got very very good at very very long formulas - the VBA is new to me - as is pivot tables.
I have the following.
a VBA form I modified that enters data onto worksheet "data", I want to be able to select a month and a year from dropdowns - hit a button - and have either something popup, create itself, or appears on another sheet.
The results being taken from all records that match the month/year, then are grouped by week# (1,2,3,4,5, etc) and summed by similarities
i.e.
Week1
there are 3 counts of day-time with xx dollars totalling - xxxx for this week/event.
and so on.
Any ideas - and please be gentle given my knowledge above.
I have the following.
a VBA form I modified that enters data onto worksheet "data", I want to be able to select a month and a year from dropdowns - hit a button - and have either something popup, create itself, or appears on another sheet.
The results being taken from all records that match the month/year, then are grouped by week# (1,2,3,4,5, etc) and summed by similarities
i.e.
Week1
there are 3 counts of day-time with xx dollars totalling - xxxx for this week/event.
and so on.
Any ideas - and please be gentle given my knowledge above.
