Hi There

I am fairly new at excel but have been asked to create a system
the worksheet that requires autofiltering is called "Employees Total Values".

The worksheet consists of;
Employee Number
Title
First Name
Middle Name
Last Name
Item Code
Quantity
Artist
Album Description
Value of Sale
Total Sum

I have been asked to create
- a report on all sales of a certain Artist (From the Artist Column)
- a report on all sales made by an employee (First Name Column sufficient)
- a report on all sales between $25.00 and $50.00
- a report showing all sales where quantity sold was greater than 3


Creating these reports using Autofilter is not the issue. I found that quite ok.
However it is creating Macro Operated buttons to each of these reports that I cannot seem to do unless I put each report on a separate worksheet.

How can I link each report to a Macro, without autofiltering all the options together, as when I created the macros for each report, when I clicked on one macro for the artist, then clicked on another for employee..The autofilter puts them both together.

I need to be able to click on each Macro so that I am provided with each required report as listed above in purple.

Could someone please assist me?

I know nothing about VBA code

Thankyou
Meekie