Trying to make a program for my sheet to fill in info automatically

  • I am some what new when it comes to excel. I have some basic programming formulas but a fast learner. I found this on line and down loaded and it looks interesting and wanted some help to see if anyone could make this sheet run by itself. I will try my best to explain. There are 4608 different ways to put thee letters in a specific cell. Every time you enter a new combo it will display the answers which are numbers in the columns over in AI through AN down to row 72. If you put certain combos in it will not leave any numbers in AI through AN and that is okay too. I just want to know what numbers are left for each combo when this program runs. I think you call the programs a macro. I have listed on the spreadsheet all the different ways to make the combos work and the sheet is called different letter combos. Where the different letter combos have to go is the sheet called The Game. I have placed formulas in the cells on The Game sheet so you can see where they go back to. I want to run all the way down from row 1 down to row 64 placing all these combinations in from columns E to CE. If you can imagine clicking on a button or making the program RUN and then it starts loading the letters into the cells on the sheet called The Game as it works its way through all the different combos. I am sure someone on here is capable of figuring this out. I know it would take me years to learn what you experts already know and I am much obliged by your help. I am sure you may have questions and I will do my best to answer them


    Gratitude
    Ace


    ozgrid.com/forum/core/index.php?attachment/65712/

  • Re: Trying to make a program for my sheet to fill in info automatically


    Mr Pike,


    My name is Asa, I go by Ace. I am student at Texas A&M. Perhaps you sent wrong message to me or mistaken me for the person you call Larry that goes by larbec or luckyjack in which I have copied his sheet in hopes to play games as Jack/Larry/larbec/luckjack does.

  • Re: Trying to make a program for my sheet to fill in info automatically


    Quote from pike;749213

    Hmm interesting but you use the same computer and IP address


    any who .. It will be relatively easy if we know the combination algorithm


    then it can be placed into a macro that will populate the cells


    hmm, perhaps the same ip address due to college library access where I use the computers. You gave me idea so i sent hiim a private message, he must be here at A&M Texas too. I will ask for algorithm
    .
    Gratitude
    Ace

  • Re: Trying to make a program for my sheet to fill in info automatically


    From another forum when I ask for help with excel. I sent private message waiting for reply. Do not sweat it Mr Pike. I am sure to get response

  • Re: Trying to make a program for my sheet to fill in info automatically


    Quote from KissAce;749048

    I am some what new when it comes to excel. I have some basic programming formulas but a fast learner. I found this on line and down loaded and it looks interesting and wanted some help to see if anyone could make this sheet run by itself. I will try my best to explain. There are 4608 different ways to put thee letters in a specific cell. Every time you enter a new combo it will display the answers which are numbers in the columns over in AI through AN down to row 72. If you put certain combos in it will not leave any numbers in AI through AN and that is okay too. I just want to know what numbers are left for each combo when this program runs. I think you call the programs a macro. I have listed on the spreadsheet all the different ways to make the combos work and the sheet is called different letter combos. Where the different letter combos have to go is the sheet called The Game. I have placed formulas in the cells on The Game sheet so you can see where they go back to. I want to run all the way down from row 1 down to row 64 placing all these combinations in from columns E to CE. If you can imagine clicking on a button or making the program RUN and then it starts loading the letters into the cells on the sheet called The Game as it works its way through all the different combos. I am sure someone on here is capable of figuring this out. I know it would take me years to learn what you experts already know and I am much obliged by your help. I am sure you may have questions and I will do my best to answer them


    Gratitude
    Ace


    ozgrid.com/forum/core/index.php?attachment/65712/



    Ace,


    I responded to your PM. I am not sure where you found this but let me try to explain. Number 1 there are not that many combinations and only 512. Not sure where you got that many from Lordy LOL. Look me up when you are at school. I will be there most of this coming week. I'm already working on the Macro and almost have it complete. As far as getting it to do what you expect that won't happen. You need the rest of the puzzle so to speak. I am sorry to tell you i will not be giving that out so what you are trying to accomplish is useless to anyone else besides myself. I have made so much progress the past 8 most its overwhelming. Like I said, come by and talk to me and perhaps I can help you out with what your needs may be besides my spreadsheets.

  • Re: Trying to make a program for my sheet to fill in info automatically


    Quote from pike;749104

    Larry what are you doing


    So fast to accuse much like our Government, guilty to proven Innocent LOL How are you Pike? You ask what I am doing? Doing what some say is impossible Making money (-:

  • Re: Trying to make a program for my sheet to fill in info automatically


    Quote from pike;749352

    Larbec is in the library he has posted at chandoo


    Actually I am in the lab LOL, keeping tabs on me

  • Re: Trying to make a program for my sheet to fill in info automatically


    hello larbec,
    maybe you can determine what ace is asking for .. he is at the same location
    asa is the first name and it will not be to hard to find them
    he/she may have unauthorised copy


    if to many of the system busting spread sheets get out .. the lotto people will have to shut you down


    interested on how he would like to automate the sheet .. do you know what he/she means?