•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to create an if then or if then for a drop down menu
Our take
Creating an interactive dropdown menu in Excel can be a game-changer for your data management. By setting up an "if-then" function, you can ensure that selecting an item, such as "160×60" or "160×50," will automatically display corresponding text in another cell, like "4 wheel unit" or "6 wheel unit." Additionally, you can populate a cell with today’s date to keep your data organized and current. Let’s simplify this process together and empower your spreadsheet skills for more efficient workflows. Cheers!
It's been a good while since i have used excel. I'm trying to create a sheet where if you select an item say 160×60 or 160×50 then it will bring up text in another cell say 4 wheel unit or 6 wheel unit and also populate a cell with today's date. I've been trying all morning, but my brains collapsed.
Cheers in advance
[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]
- Countif or sumif when adding from a selection of a drop down and the range is in a different columnHi Reddit, I have a column for drop-down selection for machines and another one for time keeping. I'm trying to map out how long each machine is down for and use a pivot chart to make it visual. Any combinations of formulas I come up with come up broken. Any advice is appreciated - even chart visual. TYIA submitted by /u/HellsLamia [link] [comments]
- Looking for advice: uniting grocery shopping listsGreetings excellent people! I used to be a bit more proficient in Excel, nowadays I can use functions but have a little bit of a hard time getting where I want. Case is this: (sorry if some words aren't PC, I'm not a native speaker) I work in a residence where differently challenged and challenging people live and are assisted in their daily lives. I want to create an Excel file where different people write their shopping lists (grocery) and those (like 5) lists are brought together and added up into one list. Now, with a set list of given groceries where people just add in numbers (like eggs: ..., apples: ....,) I do not have a problem. What I want is for people to be able to add their own items, that are then added to the summary list (bonus if similar items are put together). I am already trying stuff and will possibly get back here when I have more specific questions; at this time I'd like to ask for general advice or tips that come to your mind if you hear what I'm trying to do. submitted by /u/roastbrain [link] [comments]
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#excel#if then#dropdown menu#cell#populate#text#160×60#160×50#sheet#4 wheel unit#6 wheel unit#selected item#date