•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I use dropdowns to change data in a table?
Our take
Struggling to create a dynamic display in your spreadsheet? You’re not alone—many users find it challenging to set up dropdown menus that pull data from other sheets. Luckily, this process is simpler than it seems, especially if you’re using tools like Google Sheets. In this guide, we’ll explore how to use dropdowns to change data in a table, providing a clear, step-by-step approach to achieving a clean and organized presentation. Let’s transform your data into an easily navigable format that enhances readability for all users.
This is a pretty strange question and I don't know if I'm describing it right in my title, but basically in one spreadsheet I want to have one or two sheets with some data sets and then a third with a drop down menu that will display data from those other sheets. I know this is possible because I've seen it done with the Helldivers 2 Divers Dex, found here if you need an example of it: https://www.reddit.com/r/Helldivers/comments/1cec9l4/diversdex_your_pokedex_but_for_helldivers_2/
I don't need to do any calculations so my project should be a lot easier to work on. I already have all the data saved in one sheet but it's not easy to read, I just need to know how I could set up a display similar to how the creator of that other spreadsheet did it, I've also reached out to them and they did try to answer the question but I think they didn't understand me correctly and haven't gotten back when I reached out again.
If this answer requires Google Sheets then go ahead and tell me, It would be easy to switch my project to that program, but I'd still appreciate an answer.
Quick edit: I plan on hiding the sheets I'm puling the data from so users can't see them, it's not important for the question but some people might not understand why I want to use another sheet in the same file.
[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]
- In series drop down filters from multiple sheetsPortion rant and question. Unfortunately, being able to create pivot tables has earned me the title of "Excel Wizard" in my office, and I have been tasked with creating a dashboard to pull filtered data from several sheets easily. The database I am pulling from is fairly large, and outside of my abilities, YouTube and online searches are not getting me the exact answer I need. In theory, the end result will be a dashboard with two dropdown filters. The first is to select the specific location (37 total), and the second is to select information from 10 separate sheets, like contact information, contract expirations, insurance policy information, equipment information, etc. They would also like each category to have its own sheet so the information can be looked at as a whole. I have pushed to have seperate excel files for each location with the information needed, but they want one place to view and edit all of the data. The other caveat to this is that since pivot tables are a mind-boggling creation, I fear any complex formulas or functions may get damaged as they try to edit/update information in the data sheets. My initial thought was to consolidate all of the information onto one sheet, but the different headers/information types stopped that plan quickly. Besides advocating more for some type of software to store this information and accomplish this "dashboard" need, is there a solution to my problem? submitted by /u/Few-Combination-9985 [link] [comments]
- Creating a graphic with custom located cells populated by a pivot tableI want to create a graphic with drop down menus that work off of each. So, I select the "Bore size" and the "Class". After I want custom placed cells to populate with the appropriate information based on a separate worksheet that has all of the information for each value. (First Picture Below) Red represents my drop down menus. Once I have populated that, I have a separate spreadsheet (pictured below) with the columns detailed for which variable they are to fill, and it will give me my values accordingly. What terms and capabilities with Excel should I be researching to be able to achieve this? I'm assuming "Pivot Tables" for referencing the information from Sheet 2 to Sheet 1, but I don't know how to get the information to place itself appropriately into the blue sections. Do I have to merge cells to fit there, or can I draw custom cell placement? TIA Also, does anyone know what you would call this type of chart in Excel? The best answer I have so far is "Lookup-Driven Dashboard". Sheet 1 https://preview.redd.it/o4ptbz0ayvmg1.png?width=1325&format=png&auto=webp&s=bddd06bc28023fba707942fd7bdade6341447e7d Sheet 2 https://preview.redd.it/3odfm92ryvmg1.png?width=472&format=png&auto=webp&s=a7c3c27880a79f63916ccc8ff5a1064458bcd239 submitted by /u/West-Doubt6824 [link] [comments]
- Linking up multiple spreadsheetsHey guys! I am in a bit of a situation and I don't even know how to search for it (I really tried). I need to link multiple spreadsheets and gather data from them. Here's the breakdown of the situation: Main spreadsheet - Contains all customer data, such as name, address, phone number, email, notes, etc.. You get the point. For each individual customer I will be having a Profit and Loss spreadsheet, which contains more and specific information, but also the information that will be found in the main spreadsheet. Every customer will have a folder which also has the P&L spreadsheet in it. Is there any way I can make this more streamlined, besides double inputting all the data in both spreadsheet? I want the main spreadsheet to pull up the information automatically the data from each individual customer. I create the P&L where I will be filling out the information then I want the main spreadsheet to automatically get the data from that, as simple as possible. Sorry if this is a little confusing, I am trying my best to explain it haha. Thank you! submitted by /u/ionutzz__ [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#google sheets#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#rows.com#financial modeling with spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#natural language processing for spreadsheets#Excel compatibility