•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Help for a vocab sheet - how to filter ?
Our take
Are you looking to enhance your German vocabulary learning experience? If you're managing a master sheet with various words and want to create subcategory sheets based on grammatical functions like verbs or noun genders, you're in the right place. Filtering your data effectively will allow you to keep everything organized and automatically updated as you add new words.
Hey guys !
Seeking help for a German vocabulary sheet I'm doing to keep track of new words I'm learning.
I have a 'master' sheet with everything - but I'd like to create sub categories sheet based on the grammatical function of the words (verbs, gender of the nouns etc...). How do I filter that and keep it updated so that every time I write a new word it automatically comes up in the other pages ? I have multiple columns in the 'master' sheet (see picture).
Hopefully what I want to do is clear and you guys can help me, I'm really bad at excel and just trying to make my vocab learning a bit easier !
thanks x
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to confront multiple sheets against each other?English is not my first language, if anything doesn't make sense pls ask. I am currently trying to filter a bigger excel for a conference programm, their file was divided as such sheets: Day 1, Day 2, Day 3, Day 4 -> this containes, for each day in the title of the sheet each conference title for a given room at a given time. I created other sheets, which i named as the main topic. for example: Hybrid if the sheets containes mentions of hybrid as a word in the session or title of the conference. I am now stuck, since I only searched my main interest and created new sheets only for the word I choose. I now have a incomplete subdivision, since I didn't copy each and every conference. I would like to create a new sheets named OTHERS in which I import any conference I don't have in the specific sheets I created. So for example if in Day 1, row7 column 15 never appear in each new sheets I created (hybrid, liquid, ...) I want that row imported in the sheets OTHERS. Is there a way to do this, even only by finding the single row# column# and then I can manually create the table for the new sheets OTHERS. Or I just need to filter manually or use an AI (which i don't like to do since I want to use excel if possible) submitted by /u/Candid-Note6320 [link] [comments]
- Using Data from Two Sheets to find classesI work in a corporate job and somehow became the person on my team that knows excel best. I’m okay with excel. Not an expert. But I need help. I have a spreadsheet that lists available training classes and how many seats the class has and how many are still available. I also have a sheet of learner requests for classes. I would love to combine the data and be able to query or pivot to show a list of students that could be enrolled into available classes. What’s the best method of going about that? Thanks. If I need to go elsewhere to ask questions like this please direct me. Thanks. submitted by /u/Coffee4words [link] [comments]
- How do I filter out cells that I want so then I can copy the information next to it to paste the filtered data onto a new sheet?im new to using excel because of uni and im struggling trying to filter my data so that i can calculate confidence intervals. So basically i started off with two columns cbd dist and median price, but i need to assign words to the cbd dist values (the cbd dist values r in km, and inner is assigned to a value that is less than or equal to 14.75km) which i managed to do after ages googling. However now I want to only copy the inner group and its corresponding median price values so that i can paste it nicely on another excel sheet for my calculations (as its mixed with outer right now, i also need to split the values so i just have a list of outer and its numbers). So I need something where i can highlight all the inner and then just control shift left so i can get the median values. Does anyone know how I can do this?? Thanks in advance and I’d really appreciate all the help I can get as im stumped atm. Also im new to this subreddit and my old post with an image of the data got removed, lmk if you guys need a ref submitted by /u/EstablishmentAny4929 [link] [comments]
- Want to copy data from master sheet to seperate sheetHi, I am an excel newbie and I would have added a screenshot but it is all in Dutch. I am in charge of the guestlist for a big company multiple day event in October. Right now I have everyone in one sheet with their names and contact information and also a column (M) which is the day they will be invited for the event. it's either on the 30th of september, 1st of October or the 2nd of October. I do not know if it is possible but I would like to have the whole row copies to a different sheet when I fill in the date they would be invited on. So if person A gets an invite for 30/09, I would like the full row of their information to be copies to my different sheet that is specifically for all the guests of 30/09. This way I have my own sheet with everyone that is invited from 30/09 until 02/10, and then different sheets per day. Is this possible to do this with a formula or something more automatic instead of copy pasting the lines myself? Thank you submitted by /u/Necessary_Fennel581 [link] [comments]
Tagged with
#Excel alternatives for data analysis#machine learning in spreadsheet applications#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#rows.com#cloud-based spreadsheet applications#real-time data collaboration#financial modeling with spreadsheets#real-time collaboration