At this point I have no idea what you want to do.
Your first post says, "Then I use a macro I made to reformat the data into csv,......"
Let's say this is your data.....
4105,10/17/2022,Mon,12-19-25-29-36-37,158,4/2
4106,10/19/2022,Wed,31-32-33-36-42-49,223,3/3
4107,10/22/2022,Sat,02-11-13-21-24-46,117,3/3
4108,10/24/2022,Mon,15-23-34-35-37-49,193,5/1
4109,10/26/2022,Wed,10-20-42-44-47-49,212,2/4
4110,10/29/2022,Sat,03-07-09-24-36-37,116,4/2
4111,10/31/2022,Mon,14-21-26-31-35-49,176,4/2
4112,11/2/2022,Wed,28-36-37-42-43-49,235,3/3
4113,11/5/2022,Sat,01-03-05-25-30-41,105,5/1
4114,11/7/2022,Mon,06-14-35-39-46-47,187,3/3
4115,11/9/2022,Wed,11-14-18-22-27-32,124,2/4
And you want it all in CSV (comma separated format)....
Open it in Notepad.
Click Edit.
Click Replace.
In the first block, type "/" (without the quotes)
In the block below, type "," (without the quotes)
Hit Replace All.
You now have this.....
4105,10,17,2022,Mon,12-19-25-29-36-37,158,4,2
4106,10,19,2022,Wed,31-32-33-36-42-49,223,3,3
4107,10,22,2022,Sat,02-11-13-21-24-46,117,3,3
4108,10,24,2022,Mon,15-23-34-35-37-49,193,5,1
4109,10,26,2022,Wed,10-20-42-44-47-49,212,2,4
4110,10,29,2022,Sat,03-07-09-24-36-37,116,4,2
4111,10,31,2022,Mon,14-21-26-31-35-49,176,4,2
4112,11,2,2022,Wed,28-36-37-42-43-49,235,3,3
4113,11,5,2022,Sat,01-03-05-25-30-41,105,5,1
4114,11,7,2022,Mon,06-14-35-39-46-47,187,3,3
4115,11,9,2022,Wed,11-14-18-22-27-32,124,2,4
Do the same steps.
This time in the first block, type "-" (without the quotes)
In the second block, type "," (without the quotes)
Hit Replace All.
You have this.....
4105,10,17,2022,Mon,12,19,25,29,36,37,158,4,2
4106,10,19,2022,Wed,31,32,33,36,42,49,223,3,3
4107,10,22,2022,Sat,02,11,13,21,24,46,117,3,3
4108,10,24,2022,Mon,15,23,34,35,37,49,193,5,1
4109,10,26,2022,Wed,10,20,42,44,47,49,212,2,4
4110,10,29,2022,Sat,03,07,09,24,36,37,116,4,2
4111,10,31,2022,Mon,14,21,26,31,35,49,176,4,2
4112,11,2,2022,Wed,28,36,37,42,43,49,235,3,3
4113,11,5,2022,Sat,01,03,05,25,30,41,105,5,1
4114,11,7,2022,Mon,06,14,35,39,46,47,187,3,3
4115,11,9,2022,Wed,11,14,18,22,27,32,124,2,4
Everything is now in CSV (comma separated value format). Save your file.
You can now open it in Excel and delete any columns you don't need.
A macro is overkill when there is a simpler means to achieve a goal.
Now you say...
"If I can predict the equations for the next draw....."
You are not alone. Predicting the equation for the next draw is a worldwide problem!
But I originally thought what you were asking was......
I want to input this set (from above) 4114,11,7,2022,06,14,35,39,46,47
and use an equation to
output this set (from above) 4115,11,9,2022,11,14,18,22,27,32
....and that doesn't sound like what you are saying now.
Sounds like you have some outside, unknown input you plan to use with the equation?
Extremely confusing.
G