excel

You are so right ,

I may have to start looking at a VBA for Dummies course .

Thanks To everyone who replied

I learn even through my mistakes

Carlig

replyed to your e-mail. success will wait to hear . shall i delete the one you just sent along with all the others/?

Carli,  Retxx might be able to open it and use in oen office or possilly google docs either would keep the marcos , instead of downloading he could use the file in either place but you would need to upload to google docs.

Thank You susscs

I honestly wasnt aware that google docs allowed macros, thats good to know.

Another helpful Lper did Pm me a code solution, so for now at least Rettx is back is business .

I do appreciate everyones input and advice .

This was my first attempt at using a macro in a sheet I posted and I should have understood it myself before posting it.

Thank You All

Carlig

@retxx

I suggest that you buy a new computer, when a good version of Windows 8 comes out and the newer version of MS Office.
Also you might get a few evening classes of VBA Excel to get a kick start. Teachers can answer questions, books can only be read.

How true, I'm still adding new features to my old GWBasic programs.  Now the only problem I will eventually have they won't run on the newer machines once my XP machines stop working.  I just wished I had invested in a better XP laptop.

RJOH  if you can program in GWBasic you can use VBA.  just a few differences and you are there.  I used to do everything in GWBasic, had a little problem with some simple things at first. fellow LP'ers helped.  VBA is easier than GWbasic, 80% or more of the syntax is the same.  getting information in and out is different, but easier once you understand it, and it will work with any version of windows.

hi carli its 8:23 pm I just downloaded what you sent it opened and ask to enter a number which I did and click ok next screen came up on line 11774 the number appeared but gave no list of predictions

what about that idea by susss to google and try that?
Boy we sure are getting  help aren't  we

If you want to try opening in Google, thats up to you. I cant do it for you because of course mine works just fine lol

CG

I bought a copy of VB6 some years ago but never got around to learning enough to use it.  Before then I bought a Quick Basic compiler and was learning QB until I learn the QB compiler could compile GWBasic programs.  Even downloaded a copy of JustBasic with its tutorial and thought if I learned it I might buy a copy of Liberty Basic which seems closer to GWBasic than VB.  At my age, it's just easier to go with what I already know until I have to learn a new way to do the same thing.

carli you are not going to believe this but phileight suggested  I change the name of lookuo to another. I did and lo and behold when it ask for a number to enter it prints out the rows and columns to the right that you had sent me. wow wow wow.explain what i get if i enter into draws 2,3,4,5

question carli how can we get that list to change to show tiers. Can it be done if I e-mail it to you?

Wow, Im so glad She / He was able to resolve it for you .. The only reason I put the extra buttons  2 3 4 etc was if you wanted to do maybe the previous draw also

or if you wanted to look up the different permutations like , 123  132  231 213  etc .

Where did I get the tiers, you asked ?  By using the Deflate tool on Lottery Post

CG

carli I seem to have had some luck with the tiers so can you do this for me. i will give you sun mid and eve numbers sun eve. Could you do a combine the 2 for me and post the upper tiers and i will play them for the whole week. Thanks for your help.