Excel Help!
Im building my own collection tool and need some help.
Im trying to create a drop down menu in a given cell where I can modify the entire row for that particular game. I have posted a screen shot of what im talking about to make this easier to understand. I have the intial drop down box set by doing "data validation".
So from the drop down box id like to be able to pick out a game and than i want the ENTIRE row to be modifiable so that way whatever i modify in this row of cells under each category, it will reflect on the actual row in the list below. . So, I pick my game, and i can modify whether its been graded, date aquired, etc... simply from this row as opposed to having to scroll down each time to do it. Anyone know a simple macro available or code to reflect all the changes in the row according to the game i choose from the drop down box? thanks!
Thanks!
Comments
So lets say row 27 is Adventure island 3. You pick it from the drop down box in row 7? And then you want to be able to modify B, C, D, etc, while in row 7, and then have your modifications you just made in row 7 be copied to row 27? Is that what you are asking????
Then click on your heading title (NES Games list), go to Data -> Filters -> Autofilter. When you turn autofilters on, your heading now becomes a drop down box itself. Simply select the title that you want, and all other rows will magically be hidden. Now you edit everything right here, turn the autofilter off and wa-la, your data is updated.
Hope that makes sense.
But with a list of 700+ games, I don't think selecting one from a drop down would be easier then scrolling down to where the game is at. What I do, is I just have panes frozen so Title, CIB, and what ever else I am tracking is static on top, and use find [ctrl+f] when I need to update a title.
Not to mention, you can also sort ascending or descending with the click of a button. Autofilters are quite powerful, yet not used by many? No idea why, they're really quite simple.
You can do a lot with the autofilter command, I just answered his question. You can set it to display all A titles, display all titles between B and D, display all titles containing a phrase (Like Mario?), display all titles ending in 2 (for sequels), etc.
Not to mention, you can also sort ascending or descending with the click of a button. Autofilters are quite powerful, yet not used by many? No idea why, they're really quite simple.
They're probably not used by many because databasing isn't the primary purpose of Excel.
Most people savvy enough with database creation to know about autofiltering are probably using actual database software instead of shoehorning a spreadsheet into a job for which it wasn't intended.
I just got back from work and thanks for all the replies! You guys are on the right track. The actual list starts at row 9. Rows 6 & 8 are just spaces in between to make it look "pretty." Row 7 is the drop down box area to fill in what needs to be filled in. I'll update everyone on my progress! Im gonna try the auto-filter thing and see if that works.
To answer an earlier question (which i think everyone seems to have an idea of what im doing); Im trying to be able to modify any game in row 7. Meaning if "Mario brothers" is on row 200, I want to be able to pick it from the drop down box in row 7, modify it with the info, and at the same time it is being updated on row 200. I also need to be able to delete that info from row 7, once im done updating, and move on to another title without row 200 being deleted as im moving on to update another title.