Forum Discussion
I need vba code or function to automatically put data in next selection
I attached file. i have a button that update worksheet each round. i want function to update when iput score in
Thanks You
sf49ers19238597 Interesting that your name is sf49ers but have chiefs winning ...
Sooo you can add a Worksheet_Change function and see if the score values changed and if so then run the macro but why have a macro at all?
I have recreated the macro action using in-cell formulas for the top half so it will update those later games automatically when you enter the scores. I left the lower half and any further clean-up for you 🙂
see attached
sf49ers19238597 I don't understand what you mean by that. Here is a screenshot where I changed Vikings to Giants and changed the Eagles score in the first game to 22 pts (and hence win):
notice how the Eagles and Giants are now listed in the second games
Now I changed the Saints to the Lions and their score to 30 (and hence they win):
notice how not only does the Lions appear in the second game now but they are against the Packers and the Eagles got bumped down to go against the 49ers because of their respective incoming rankings.
Let me know what isn't working so I can understand and help.
I do not know that was made by a friend of mine
Thanks you
