I need vba code or function to automatically put data in next selection

Question

I have playoffs file one my friend help me. I have press a button or switch to different worksheet to update data after I type in all score. How I make it automatically put data in?

Thanks You

mathetes · Answer

sf49ers19238597&nbsp;&nbsp;You've had a lot of views (over 60 as I write this) but no replies. I think it's because your request is quite confusing. Is it possible for you to post a copy of the spreadsheet itself? Without that, I doubt you're going to get any further response.

sf49ers19238597 · Answer

mathetes&nbsp;&nbsp;I attached file. i have a button that update worksheet each round. i want function to update when iput score in&nbsp;&nbsp;Thanks You

mathetes · Answer

sf49ers19238597&nbsp;a) I am unable to open the spreadsheet except in "Read0-Only" mode, butb) even if I could open it with full functionality, it's not clear what "update" you want after entering data.&nbsp;It's possible that someone else here in the techcommunity can take it further, but I suspect you're going to need to provide a bit more background info on what this spreadsheet is supposed to accomplish, what a macro or VBA routine is supposed to do. "Update" is ambiguous. To enter data, per se, is to update. What else do you want?

mtarler · Answer

sf49ers19238597&nbsp;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.&nbsp; I left the lower half and any further clean-up for you 🙂see attached

sf49ers19238597 · Answer

I do not know that was made by a friend of mine&nbsp;&nbsp;&nbsp;&nbsp;Thanks you

Forum Discussion

I need vba code or function to automatically put data in next selection

7 Replies

Resources