hi everyone... long time listener first time caller here from australia...
so basically my problem is massive.
for a senior finals assignment at school i have to use the advance filter function in a macro to create a semi automated filtration of a client list, problem is i suck at recording and coding macros that have more than one procedure.. please help
criteria is as follows
You are required to use the Advanced Filter tool on this worksheet to allow
users to filter (in place) the Clients worksheet while providing the following database
statistics: total, average, maximum and minimum revenue per client, and the total number of clients/tours. That is, users should be able to enter any criteria value below the Clients database and invoke the advanced filter tool to show only those records, and the summary statistics for those records, that satisfy the given criteria. Note that average calculation should have value of zero if no records satisfy the given criteria.
You must include three macros in your finished Clients worksheet to automate
operation of the filter tool. The first two macros are entitled 'SelectClient’ and
'SelectLanguage'. Once invoked, these macros should prompt the user to enter a value through an input box in order to filter the data range in place according to a client's last name or language tour, as appropriate. A third macro, called 'ShowAllClients’, should clear the criteria row and display all clients in the database. The first two macros should include an error message (e.g. “Please re-run the macro!”) to prompt the user to rerun a macro if no clients satisfied the criteria while the 'ShowAllClients' macro should include a message box statement at the end to display a short message giving credit to the macro authors (e.g. “This macro was created by <insert your name here>!”). Finally, assign and name one button to each of these macros (three buttons in total) on the Clients worksheet
if anyone could either wrote the coding i need for the macros or put them into the attached workbook and reattach it it would be most appreciated as i am going out of my mind trying to figure this out, and if i see it done once for one of my several work books i should be able to implement it into my others..
thanks in advance,
ryan
Bookmarks