Objective: Create a macro that automates the process of registering 6 subspreadsheets from the main spreadsheet and performing statistical analyzes on each of them.

Phases:

1. Registration of Subspreadsheets:

Select cell A1 on the main worksheet.

Run the macro.

The macro will create 6 new subsheets with the following names:

Worksheet 1 - PTT

Worksheet 2 - PTM

Worksheet 3 - PT

Worksheet 4 - PTV

Worksheet 5 - PTN

Worksheet 6 - OWL

2. Statistical Analysis:

In each subsheet, the macro will perform the following analyses:

Counting digits from 0 to 9: The macro will count how many times each digit from 0 to 9 appears in the drawn numbers.

Pattern Count: The macro will count how many times each of the following patterns appears in the drawn numbers:

Pair: 0, 2, 4, 6, 8

Odd: 1, 3, 5, 7, 9

High: 5, 6, 7, 8, 9

Low: 0, 1, 2, 3, 4

Presentation of results: The macro will present the results of the analyzes in a table next to the list of draws.

well you asked for an example, we then have 6 results from pick3 and 4 in a spreadsheet, the results are For example, they will be changed and placed every week, but the macro can give you the limit of 10 thousand draws

in the list of 0 to 9 is to see how many of each digit was drawn, and another list and put in descending order from the most drawn to the least drawn

Ha, you can do these statistics by adding the 6 spreadsheets too, do you have any doubtshttps://www.mediafire.com/file/aj080lbzlk5gsol/pasta+para+6+sorteios+pick3+e+pic4.xlsx/file