#1: Make two buttons to sort the table by Employee Name or by Client Location.
In Excel, name the first cell of the employee table. In VBA, dynamically name the entire table (with labels). Sort in ABC order.
#2: Make two buttons to highlight table rows with Number of Night values Smaller or Larger than a given value.
Dynamically name the table (no labels). Clear previous formatting rules. Select the table and add new formatting rule.
In Excel, name the given number of nights value cell. Highlight rows with smaller costs green and larger costs yellow.
#3: Make a button to calculate a report of the Min and Max Costs in the table.
Dynamically name the table (no labels). In Excel, name the Costs Report column cells. Use Application.WorksheetFunction to calculate min/max table costs.
#4: Make a button to calculate the total nights and total costs for a given Employee.
Dynamically name the table (no labels). In Excel, name the given Employee name cell as well as the Total Nights and Total Cost report row cells.
Use Application.WorksheetFunction to calculate sum of nights and sum of costs for given employee.

Practice 5 Create a dynamic Interface to evaluate employee travel costs. User should be able to sort, format, and calculate report 4 questions #1: Make two buttons to sort the toble by Employee Name or by Client Location In Excel nome the first cell of the employee foble. In VBA, dynamically name the entire toble (with lobeli). Sort in Anc order. 12: Make two buttons to highlight table rows with Number of Night values Smaller or larger than a given value. Dynamically name the table (no labels). Clear previous formatting rules. Select the table and add new formatting rule. in Excel, nome the given number of nights value cell. Highlight rows with smaller costs green and larger costs yellow. 13: Make a button to calculate a report of the Min and Max Costs in the table Dynamically name the table (no labels). In Excel, nome the costs Report column cells. Use Application WorksheetFunction to calculate min/max table costs. 14: Make a button to calculate the total nights and total costs for a given Employee Dynamically name the table (no labels). In Excel, name the given Employee name cell as well as the Tool Nights and Total Cost report row cells. Use Application WorksheetFunction to calculate sum of nights and sum of costs for given employee Sort by Employee Sort by Client Location Highlight Number Nights Nights Highlight Smaller Highlight Larger Conts Report Min Max Employee . Gorcio 5. Tiago A Blakber F. Garcia D. Edwards D. Edwards 2. Qul P. Gul A. Bilakbar C Denvers F. Garcia G. Hol C Denvers F. Gorclo G. Hol P. Qui 5. Tiago El Fernandez E Fernandez Paul Number of Nights 2 4 5 5 1 1 2 3 3 4 2 1 1 4 Calculate Report Client Location Arlington Arlington Atlanto Atlanta Baltimore Baltimore Baltimore Boltimore Charlotte Charlotte Charlotte Charlotte DC DC DC DC DC Richmond Richmond Richmond Total Cost $562.50 $462.50 $650.00 $750.00 $675.00 $475,00 $575.00 $475,00 $250.00 $250.00 $350.00 $450.00 $600,00 $500.00 $400.00 $500.00 $600.00 $287.50 $48750 S487,50 Employee F. Garcia Total Nights Total Cont Calculate Employee Report 5 2 5 2 3 3