•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
QR System for Food Pantry
Our take
Hello everyone! I'm currently volunteering at a local food pantry where we've implemented a QR code check-in system to streamline the process for our neighbors. However, I'm facing challenges with the data management side. When someone scans the QR code, their information is added to a "Form Responses" sheet. I need a seamless way to automatically populate this data into our Main Data Hub, distinguishing between 'New Intake' and 'Returning Guests.
Hi everyone!
I’m currently volunteering at a local food pantry. We’ve moved to a QR code check-in system to make things faster for our neighbors, but I’m hitting a wall with the data side and could use some friendly advice.
The Setup:
When someone scans the QR code, their info is added to a "Form Responses" sheet. I already have a Main Data Hub sheet with sections ready for 'New Intake' and 'Returning Guests.'
What I’m trying to solve:
I need a way to have the scan data "populate" automatically into the right spots in the Main Data Hub so I don’t have to copy-paste every week.
- The Transition: If someone scans and they’ve never been in the system before, they should show up under 'New.' Once they’ve scanned a second time (on a different week), I need them to "transition" or be recognized as a 'Returner.'
- The Tally: I’m struggling to create an automated tally that counts these scans by week, then rolls them up into a final monthly and yearly total.
The goal is to have a "set it and forget it" dashboard so our team can focus on getting food to families instead of staring at rows of data!
Does anyone have a favorite formula or a simple way to link these together? Thank you so much for any help you can give!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Not sure how to automate counting of monitoring info gained from microsoft form, any guidance?I'd like to preface this with the facts that I'm 1. using excel for the web, and 2. very new to using excel. I work with a group of volunteers, and we have to take in monitoring information from each client we work with (think age ethnicity disability etc). At the end of the year we have to report this info to another institution. For the past few years the volunteers have been manually counting this data which takes around 10+ hours. My idea was to switch things up by having volunteers input data into a microsoft form linked to an excel file. One sheet for raw data, 12 more for each month of the year. My goal is to make it so excel automatically updates the month's count when a new client's data is added. Previously all data has been counted under the name of the volunteer who took it. The final reports look something like this: John Smith Jane Doe Age: 18-25 5 0 25-60 0 4 60+ 0 1 Ethnicity: White 2 1 Black 2 2 Mixed 1 3 Disabled: Yes 3 1 No 2 4 I have the easy part (Microsoft Form linked to Excel) done, but I'm stuck on how to get the information from the raw data 1. into the monthly sheets 2. have this information automatically add up over the year. I'm looking primarily for guidance on how to do this and what functions I should look into. I have made a table of the info in the raw data sheet which I think should help with being able to move it across the sheets. Based on research so far I think COUNTIFs may be something to experiment with? As said I'm a complete newbie, but I want to know how to do this And how the process works rather than just being handed an answer. Happy to provide more info if needed. Any resources/guidance would be really appreciated 🙏 submitted by /u/incrediblycalmwithit [link] [comments]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]
- How to autofill data from a row to a column on a different sheet in the same folder?I've been struggling with some solutions I've found on the forum but after 1.5hrs I'm close to giving up and manually entering data - which is bound to cost me another 28 hrs. Hoping someone has the solution I'm looking for and is willing to share.. I've exported questionnaire results from Mentimeter to Excel. The document output is formatted automatically in a way that uses columns for unique respondents, followed by their answers in the same column but along individual cells on that column's row, meaning the first entry is A2 and the last entry is in cell CQ2 or something. I would like to make this more user-friendly by: 1) putting each respondent's answers in their own sheet in the folder, and 2) by listing the questions in the first column and the answers in the next columns pretty much 'the other way around'. Currently it looks like this; the answers I need are listed in !VotersF3 to !VotersCQ3. The next respondent's answers are in !VotersF4 through to !VotersCQ4 and so on. What I'm looking for would ideally display answers in !AnswerA3 through to A80. When I manually select !AnswerA3 and click on !VotersF3, logically it does what I want. When I then drag down to autofill, equally logically the sheet enters !VotersF4 instead of !VotersB3 as it's a row vs column problem. I've tried different version of INDEX and TRANSPOSE but I can't get a working formula from that. Would anyone be able to provide me with the correct solution for doing this? I've got another 20+ respondents answers that need to be 'easy to view' instead of scrolling 500 screens horizontally.... Thank you Excel wizards! :) submitted by /u/Lost_Mud2097 [link] [comments]