•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Help & Advice: I need to make an excel spreadsheet linked to a form that randomly selects ~11 responses/rows & moves those responses to a different tab
Our take
Managing a patient lottery for your free healthcare clinic can be a complex task, especially when working with Excel. To streamline your process, you’ll want to create a system that randomly selects approximately 11 responses from a linked Microsoft Form and transfers those entries to a “Selected Patients” tab. Additionally, implementing features to delete responses every six months and eliminate duplicates based on phone numbers will enhance efficiency.
I am working for a free healthcare clinic, and I desperately need help with excel. For our clinic, interested patients fill out a microsoft form, and then they are randomly selected to be seen by us in the excel spreadsheet linked to the form. However, I have no experience in making this happen in excel. I am working with someone familiar with excel to make this happen, but I wanted to ask this here in case anyone has specific experience and advice in these areas.
Ideally, I need:
- To get a list of 11 random patients/rows/responses from the patient lottery responses
- To then move those responses off this tab to a “Selected Patients” tab
- To be able to delete responses every 6 months
- To automatically delete duplicate responses (likely using duplicate phone numbers)
Any help is appreciated - links, tips, etc. Thank you so much.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- using MS forms with excelHello! I have a massive spreadsheet that I need to use for lots of reporting. I've tried to pare it down as much as possible for those who have to do the actual data entry, but they are still very overwhelmed by it (they really don't understand how to even use filters to narrow down the scope) and so the data coming out is not reliable. I've never used MS forms in conjunction with excel, but I'm thinking that if I create a form for them just to enter the basics, I would at least have correct data for my analysis piece. The only thing I'm concerned about is that there are updates to entries that need to be made (ie- someone earns an additional level of certification or they drop out of the program). Can this be accomplished with forms? Or am I barking up the wrong tree. I was hoping to get some advice before I start really teaching myself how to use MS forms (any suggestions for good tutorials would be great too). Thank you in advance! submitted by /u/bluellama314 [link] [comments]
- Optimizing data entry in Excel file on SharePoint w/ 5 users: Is MS Forms + Power Automate the way?I want to optimize data entry for an Excel spreadsheet stored on SharePoint, used by 5 data enterers. It has around 300 entries/rows and 17 columns on the main worksheet. 4 other worksheets contain additional variables/columns for the same entries on the main worksheet. 8 other worksheets contain extensive instructions for the systematic literature review we are conducting. Edit: Our current approach has each of us open the Excel file in our desk top app for data entry. The issues I want to solve are: Improved data entry environment: 1) Some cells end up with extensive/long text entries. Users resize cells to optimize their view, but that screws up other people's views. We need data entry solution that allows large data entry areas for certain Excel cells, but not others. 2) Decrease users mistakenly entering data in wrong cell. formatting issues caused by each user doing their own rogue formatting (Despite discussing not messing with formatting in couple of meetings, these people, led by our boss, keep doing it!) excel sheet freezing for short periods of time mouse pointer highlighting cells above the cell to which it is pointing A bit of Googling led me to MS Forms + Power Automate. Would this solve the issues described above and be stable. Is there a better solution? Background Info I'm an intermediate/advanced excel user with experience in VBA, SQL, and stats packages (eg, SAS) working at a large federal agency Excel version: MS 365 MSO v2603 We have MS Forms and Power Automate in-house submitted by /u/tenbsmith [link] [comments]