Excel Question re: Macros

Reply #23

Elizabeth03 — Fri, 20 Jul 2012 21:57:35 GMT

I like the system that you play butch, do you win very often

Reply #22

LottoBoner — Fri, 20 Jul 2012 13:18:28 GMT

Reply #21

time*treat — Fri, 20 Jul 2012 13:16:33 GMT

Everybody was mac-ro fighting ...

Their codes ran fast as lightning ...

Results were a little bit frightning ...

Marking playslips with expert timing ...

Reply #20

hotshot4 — Fri, 20 Jul 2012 12:32:20 GMT

A B C D E F G H I J

23 14 10 36 2 46 =SMALL($A1:$F1,1) =SMALL($A1:$F1,2) =SMALL($A1:$F1,3) =SMALL($A1:$F1,4)

Copy down as far as needed using the paste options Fx

I only used 4 digits but you can use as many as needed

Reply #19

SergeM — Fri, 20 Jul 2012 11:06:06 GMT

I have the same code than time*treat, but I also use the built in sort.

You progress by using the recorder. It is the best aid that you can get.

Reply #18

LottoBoner — Fri, 20 Jul 2012 10:59:22 GMT

Let the battle of the Macros begin

Reply #17

SergeM — Fri, 20 Jul 2012 10:40:25 GMT

Another recording, without breaking up the lines:

Sub sort()

'

' sort Macro

'

Range( B2:H2 ).Select

ActiveWorkbook.Worksheets( Blad1 ).sort.SortFields.Clear

ActiveWorkbook.Worksheets( Blad1 ).sort.SortFields.Add Key:=Range( B2:H2 ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal

With ActiveWorkbook.Worksheets( Blad1 ).sort

.SetRange Range( B2:H2 )

.Header = xlGuess

.MatchCase = False

.Orientation = xlLeftToRight

.SortMethod = xlPinYin... [ More ]

Reply #16

SergeM — Thu, 19 Jul 2012 22:42:35 GMT

Sorting with the recorder, you get a code like this inside of the macro.

Range( B2:U2 ).Select

ActiveWorkbook.Worksheets( Blad1 (14) ).Sort.SortFields.Clear

ActiveWorkbook.Worksheets( Blad1 (14) ).Sort.SortFields.Add Key:=Range( _

B2:U2 ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _

xlSortNormal

With ActiveWorkbook.Worksheets( Blad1 (14) ).Sort

.SetRange Range( B2:U2 )

.Header = xlGuess

.MatchCase = False

.Orientation = xlLeftToRight

.SortMethod

Reply #15

butch2030 — Thu, 19 Jul 2012 21:46:28 GMT

I tried using the macro recorder it didn't work for me. So I asked for help I got it from time*treat. I also went out purchased a book 101 Ready-to-use Excel Macros by Michael Alexander. I hope that this will give me a better insight on the macros. I am not a programmer, but usually I have a way of resolving things that need to be done. I know what macros are intended to do, I just have to figure out how to write them edit them. Being retire, I have the time to learn.

Reply #14

butch2030 — Thu, 19 Jul 2012 21:20:14 GMT

I do not play other state or country lotteries. I do look for combination and patterns in other games. I hope that by doing this - Others will realize that each game has it own combination patterns and will improve their chances of winning. You cannot change the Odds of Winning, but you can improve your Chances of Winning.

I just finished doing my combos patterns with the Philippine Lotto 6/42 game. I had download their history of the game from 01/03/09 to present. I did run into a problem as... [ More ]

Reply #13

butch2030 — Thu, 19 Jul 2012 21:12:55 GMT

Depends on the game the amount of the jackpot. I usually only play 2 cards on the IL Lotto, 2 cards on the Megaball, 2 cards on the Powerball. The IL Lotto is the best buy for me as I get 10 lines per card @ .50/line - one card is $5.00. I do play the combinations patterns that I have found in these games.

Reply #12

Elizabeth03 — Thu, 19 Jul 2012 20:42:13 GMT

butch2030, I messaged you prior, also how many combo's do you play per draw

Reply #11

SergeM — Thu, 19 Jul 2012 11:50:07 GMT

Instead of doing it manually, I am trying to convert them by using a macro.

There is a macro recorder! I suggest that you use it.

Reply #10

butch2030 — Thu, 19 Jul 2012 03:27:29 GMT

Thank you ever so much Time*Treat - It worked like a charm..........................................

I owe you one for this...................

Thanks again for everything

Good Luck Best Wishes To You.

Reply #9

Epistrophy — Thu, 19 Jul 2012 00:00:38 GMT

Time*treat, that's some nice compact code right there. Elegant is the word that comes to mind.

Reply #8

time*treat — Wed, 18 Jul 2012 23:55:36 GMT

I try to write them so it is easy enough to figure out what to change if you want to alter your starting point, range, or worksheet name, etc.

Caveat: This simple version looks at Sheet1, cols 3 through 8, starting at row 6 and doesn't check for duplicates or letters.

Option Explicit

Sub simple__sort()

'simple sorting macro'

' by time*treat '

Dim row As Long, col As Long

Dim temp As Integer, offset As Integer

Dim first As Integer, last As Integer

Dim init... [ More ]

Reply #7

butch2030 — Wed, 18 Jul 2012 17:44:56 GMT

Thanks,

I know this as I was doing it for the first couple of rows. But I have to select over 500 rows to do it all at once. It would have been alot easier to have a macro do it.

I guess I will will do it in batches of 25 rows at a time.

Thanks for your info though.

Reply #6

Epistrophy — Wed, 18 Jul 2012 16:47:32 GMT

I don't know whether this will help you, but I just tested it and you can select multiple rows and columns and still have it sort left to right.

That way, you don't need to write a macro because it can sort all the rows at the same time.

So if you select, for example, from A1 to E99 (or whatever it is on your spreadsheet) then choose Data-Sort-Options you can do the left-to-right sort all at once.

Hope this helps, and good luck.

Reply #5

butch2030 — Wed, 18 Jul 2012 12:26:12 GMT

I am trying to convert a listing of actual lottery drawings to a listing of drawings which are arranged smallest to largest numbers: For example:

Listing Before:

23-14-10-36-2-46

8-9-16-3-42-13

Listing After:

2-10-14-23-36-46

3-8-9-13-16-42

Instead of doing it manually, I am trying to convert them by using a macro. I know what a Macro does in excel, my problem is I don't know how to write a Macro.

Reply #4

ram$ — Wed, 18 Jul 2012 03:57:32 GMT

I really did not understand what you said. I wanted to help you. Can you give me any clear idea than this.

You will achive.

thanks.

Reply #3

butch2030 — Wed, 18 Jul 2012 03:48:56 GMT

Anyone else

Reply #2

butch2030 — Wed, 18 Jul 2012 03:19:38 GMT

Like I said it is not my expertise. I think I wrote one macro about 15 years ago. That was my extent with macros.

Reply #1

time*treat — Wed, 18 Jul 2012 02:47:51 GMT

If you know how to edit a macro, do a search for bubble sort macro. Make the needed changes.

Excel Question re: Macros

butch2030 — Wed, 18 Jul 2012 02:29:48 GMT

I am trying to put an out of order list of Lottery drawings in numberic order vs order drawn.

such as 6 3 2 4 5 1 with each number in a different cell - Output should look like 1 2 3 4 5 6 each in it own cell.

In excel, you can highlight the cells c6 d6 e6 f6 g6 h6 - go to Sort Filter; Custom Sort; Options: Sort Left to Right; Row 6 will appear you will sort it smallest to largest.

I am trying to create a macro so I do not have to do this on an individual line - one at a time. Have it