#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.

I need excel formulas for this question please as well as the parts 6,7 and 8. Thank you