Macro for Registering and Analyzing Subspreadsheets

Macro for Registering and Analyzing Subspreadsheets
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.

exemplo=
PTT ......GP
1- 5858 -15
2- 5375 -19
3- 5990 -23
4- 5437 -10
5- 0284 -21

======
PTM
1- 4870 -18
2- 1996 -24
3- 5717 -05
4- 6764 -16
5- 7260 -15
=========
PT
1- 9629 -08
2- 1392 -23
3- 2605 -02
4- 0105 -02
5- 5129 -08


PTV
1- 4280 -20
2- 3471 -18
3- 6075 -19
4- 6771 -18
5- 5835 -09
6- 2.6432 -08
7- 855
========
PTN
1- 2460 -14
2- 7522 -06
3- 1685 -22
4- 0755 -14
5- 4782 -21

=========
CORUJA = OWL
1- 4806 -02
2- 2117 -05
3- 4940 -10
4- 9758 -15
5- 0902 -01

hello please!!

hello, protonleah, THANK YOU FOR SEEING THE POST, sorry for the delay, as my mother was seriously ill and died only today, she went to check her emails, 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 doubts?
https://www.excelforum.com/attachmen...1&d=1712610569

Hello, what are your questions?

What is the question to create the macro?