Posts by KissAce

    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

    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


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