Help with Userform/Autofilter/VBA  
Author Message
MarthaOlson





PostPosted: Top

Excel Programming >> Help with Userform/Autofilter/VBA

I have a report that I'm trying to automate - it's one of those number
crunching sort of things. Initially I had no access to the data. Now I
have a ".cvs" file that gets dumped to me.

I have put the workbook together - but want to clean it up and
automate a few tasks.

tab 1 - I have a cover page (which I wanted to add a Userform that
allows the user to select what they wanted to do - either view the
data in charts/graphs or numbered totals) - you know sort of like a
directory - jump form - to jump to the item of interest.

tab 2 - Is the page that I have crunched the numbers and put the in-
cell 'graph' using the 'rept' function
on this page I have Totals for the group and then I've broken down the
totals for each category in the group

example:

Group Totals

Telephone/Hardware Repair
Telephone/Software
Telephone/Voicemail

and things like that...

tab 3 is the raw data - where I've used the Autofilter to provide a
total using the SUBTOTAL function.

Here's the dilemma -
I would like a Userform that allows the user to select:

1. Group Totals - or
2. Totals for Telephone/Hardware totals - or...

See where I'm going? And then have it displayed in tab 2 with the in-
cell graph.

Is this possible? I'm sure it is - but could someone help me with
this?
I would like to do it myself - but I need some serious guidance and
patience...like an outline of order of operations, I suppose, and some
help with basic commands...

I'm familiar with Case Statements - IF statements and the like - but
some times I get turned around as to what is the best way to start and
what is most efficient.

Most Sincerely,
Jae

Excel321