Many reports from one worksheet

Good day to all.
I have a few problems that I'm trying to solve using macros.
Namely, I have a worksheet called "Report" and it serves as a source of data. From that worksheet, I try to select a specific user (in this case "C") and get another worksheet that will be called "C" and that shows only what that user used (worksheet "C").

In the second case, I want to get from the same data source data related to only a certain article (in this case "A4 80g paper" in the way it is shown in the worksheet "A4 80g paper", and that in cell "A2" is the name of the item that are in the table ("Box 5 reams / 500 sheets UPM Multifunction A4 80g paper").

The third case is similar to the second only in terms of toners.

I would like to select Customer / Product from drop-down list and to get a results of selected Customer / Product in single sheet where the data relates a Customer / Product Selection.

Hi

In the attached example file, on sheet [Report] I have added a couple of 'buttons' (using Insert>Shape).
After creating macros, you can assign macros to any shape by right-clicking the Shape and then selecting 'Assign macro' from the right-click-menu.

The [Show ALL Records] button simply cancels any filtered-data, and scrolls the screen to the top of the data Records.

With Inventory data, I have often found it useful to 'filter-records-as-you-type'.
So I added a yellow textbox above the Product Item name column C. As you type in the yellow textbox, you will see records matching 'what-you-type'. For example, start typing 'paper' and you will begin to see records which include 'paper clips', 'paper refills' etc etc. Thanks to all the experts who contributed to this useful trick.

To reset, just click the [Show ALL Records] button.

The [export Customer Report] button is used to copy filtered-data-records for a selected Customer picked via the Customer filter-drop-down arrow in column F. The data records are copied to a new sheet using the Customer name for the sheet tabname.
If the Customer sheet already exists, you will be asked whether you want to overwrite it.

When records are extracted for a selected Customer, you can either keep the existing Record Numbers from the master [Report] sheet (useful for checking) or you can have the Records re-numbered for that Customer on their sheet.

As it is the season for kindness, I have also included a useful double-click-sorting feature. If you double-click on any heading cell in row 8, the records will be sorted. If you double-click the same heading cell again, the sort order is reversed. So you can easily show, for example, the Products ranked by Total Cost by double-clicking cell [K8], or easily group Products by Transaction Type by double-clicking in cell [D8], or by date order by double-clicking cell [B8] etc etc etc.

The code for the double-click feature is included on the [blankCustomer] sheet, so you can also use this double-click on Customer sheets created via the [export Customer Report] button. Thus you could double-click on the Quantity heading cell to see the most quantity items for the Customer etc etc.

This should get you started.

I noticed the Product Item sheets in your sample posted file had a slightly different layout to the [Report] sheet headings, e.g. extra columns for Consumption. It is not clear how you would want to deal with this. I have included a [blankProduct] sheet as a starting point.

If you have any questions, please ask here again. There is always help available.

zeddy
Merry Everything and Happy Always

Thanks a lot, that's what I was looking for.
And you're right, in my (A4 80g paper sheet) or your [blankProduct] sheet I only want to use for consumption of paper (Box 5 reams / 500 sheets UPM Multifunction A4 80g paper).