Use VBA to automate entry of schedule, scores

[DocAElstein]

Hello scotty68

I was thinking along the lines of the right side of the sheet, where I …..

Ah, I missed seeing all that.
Once again, I think everything will be a lot less obvious to me as I don’t know American Football, or your project as you do. Things like “ NFL scores every season mean nothing to me.

I am not quite sure what you mean by

.. When you reply, would you post in English please?

if you mean less technical jargon, then that will be a bit difficult. I have a reputation for explaining things in a lot simpler terms then most people. So I think you will never find a less technical jargoned explanation anywhere then what I give. VBA, and Object Orientated Programming is a bit of a odd concept until you know it. Even then it still has a few peculiar terms and concepts..
( If you mean about the German Excel screenshots. .. Sorry about that, but I have German Excel. ( I live in Germany ).. Usually the things I show are in the same place in English Excel, and I have mostly marked them with an arrow. In English Excel they will look very similar )

If you just want the finished answer, working, no explanations, then fair enough. Help Forums are usually not the place to go for that, only occasionally you get lucky. If you are just trying your luck, then fair enough. You more usually probably need paid professional help for that, that is to say someone to do a lot of work for you, the bulk of which is usually trying to figure out what you want in the first place! I have no idea where you should go for that, like most people here, I am just an Excel hobbyist.
I see now that you have some very large formulas with, amongst other things, Index in them.
In most cases, VBA is a much better alternative than a lot of long formulas in a spreadsheet.
So you are thinking along sensible lines. If this was my project, then I likely would have VBA in place of a lot of the formulas, and my file would probably be shorter in size. You have the right idea I think.

Unfortunately I am not familiar enough with what is going on. Probably as I know nothing about American Football and how the scoring works.
I expect the coding would be quite simple to do, and certainly simplify greatly your spreadsheet. But I would need a week I expect to figure out what is going on and what you actually need doing.

I think you will need an Excel enthusiast that is also an American Football enthusiast. As far as I know, we don’t have anyone like that here.

Alternatively you will need to break down the thing into simple plain English terms explaining what each formula does.

Usually it is easier , ( at least that is what I find ) , to do a complicated thing in VBA then in a formula. Also, usually, a single macro would replace a long list of similar formulas.
So you are thinking along the right lines.

I am not near the computer much for a couple of days. I will have some more time in a few days. If you don’t get help anywhere else in the meantime, and want to give me a clear description of what actually a formula or two are doing, ( In simple English terms, not in American Football language ) , then I will try to give you a macro or two to do the same thing.

Good luck

Alan