•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Change contents of cells based on a drop down
Our take
Managing key distributions in an office can be challenging, especially when relying on multiple PDFs and Word documents. To streamline this process, you've created an Excel template featuring a Reference sheet with all the key numbers. By utilizing a dropdown for apartment numbers, you aim to automatically populate the corresponding key numbers, simplifying the workflow. While it may seem straightforward, navigating Excel’s functionalities can be daunting. Let’s explore how to effectively set up your spreadsheet to make this process efficient and user-friendly.
So, 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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#financial modeling with spreadsheets#rows.com#cloud-based spreadsheet applications#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#spreadsheet#Excel