saeriefaeriexx
New Member
- Joined
- Nov 7, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Im brand new to macros and what they can do or even if macros is the right tool for this situation - is it possible to use a sheet to input data onto other sheets based on variables.
Ideally I want to use a form like in the attached image - one box selecting the correct game to match which sheet the data is for, and subsequent boxes to include player names followed by their scores.
Each game sheet however is listed with the player name as the header (as in other image attached). This would require and clicking the button data to be shifted to only the correct sheet and then scores sorted on the sheet to correspond with their players list.
Is this even posssible?
Thank you in advance for any advice.
Ideally I want to use a form like in the attached image - one box selecting the correct game to match which sheet the data is for, and subsequent boxes to include player names followed by their scores.
Each game sheet however is listed with the player name as the header (as in other image attached). This would require and clicking the button data to be shifted to only the correct sheet and then scores sorted on the sheet to correspond with their players list.
Is this even posssible?
Thank you in advance for any advice.