Popup to enter data into multiple cells??

vanvoord

New Member
Joined
Feb 17, 2019
Messages
5
I've been working on a google sheets spreadsheet that keeps track of our annual golf trip. During use, a user must enter scores for each player in their group. Thus, they must click on 4 different cells (one for each player) to enter the scores for each hole.

I'm wondering if there is a way to click on one cell, and a popup comes up where the user can enter all 4 scores and not have to click on each individual cell.

If this is possible, what should I search for (the technical term for what I'm trying to do) so I can find some direction on how to achieve this? Not looking for someone to do the work for me but I've come up empty on trying to find the help I need.

Thanks in advance!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
If your scorecard is set up similar to the picture below, you could use the SPLIT function in Cell B3 and copy it down. The user would then just enter the scores in the correct order separated by a comma.

=IF(F3="","", SPLIT(F3,","))

1628970102039.png
 
Upvote 0
If your scorecard is set up similar to the picture below, you could use the SPLIT function in Cell B3 and copy it down. The user would then just enter the scores in the correct order separated by a comma.

=IF(F3="","", SPLIT(F3,","))

View attachment 44850
Thanks for the reply, this could work however I was hoping for something a bit more user friendly. I may be asking to much but I'm not sure how far you can take customized scripts etc. What I'm trying to do is something like the photo attached where it shows each player and their score for the hole.
IMG_044CE7F2E61A-1.jpeg
 
Upvote 0

Forum statistics

Threads
1,223,993
Messages
6,175,838
Members
452,675
Latest member
duongtruc1610

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top