specific worksheet summary?

I browsed through existing threads and other sites and didn't find this exact scenario. I'm sorry if this type of question is common, but I wouldn't know. I appreciate any help and thanks for trying and offering your 2 cents!

OK. What I have is a table with over 20 columns that I use to sort and AutoFilter the 200+ rows of data. Several of the columns use Data Validation which require data to be from lists. Conditional formatting is used very often throughout the sheet.

Now, I want to have a second worksheet that will be almost identical to the original, but only accept rows that have certain values (let's say 3 of the 8 possible values) a specific column. These values are text values that appear in a list, and the column uses Data Validation to accept values only from that list. This second worksheet should be like if I Autofiltered the original table by check-marking 3 of the 8 available filter options for that column, but I need this specific 'view' of the data for certain purposes and my own reference.

In a perfect world, this second sheet would automatically mirror the original sheet's changes... But I don't know if that's possible? Although Excel is a very flexible and powerful tool, flexibility is relative once your tastes in data organization become more and more specific! Please let me know if any of this is impossible, so I'll stop trying to figure out how, haha.

Even if it won't 'automatically' mirror the original, I still would like to view the information in this way! Thanks for any help!

Also, I am very good with formulas and finding my way around Excel's features, but I'm not very experienced with the VBA programming or custom macro-writing.

Sorry if this is too specific or picky, but any help is appreciated, thanks!

Sure. I have made a very gutted and shortened version of my spreadsheet for ease of use for you. This is an Excel 2007 .xlsm document.

I am a video game enthusiast, and I use this spreadsheet to compile a list of video games that I am interested that are announced, dated, bought be me, etc. For regular viewing and editing, this table is usually sorted by interest level (a number I provide, based on my interest towards the game), AutoFiltered by genre or system, or organized by any other of my data.

The main reason why I asked my question was so I can make a "backlog" of games that I want to play next or need to beat eventually. Thus, making a 'new view' of my data filtering out any games I don't own, have already finished, etc.

Originally Posted by mewingkitty

So you want to, for example... list games which you haven't beat, do not own, and have a higher than 80% interest in, in order of interest on this second page.

maybe?

Or are you looking for something more simple like a checkbox system where you can hand pick games you want to buy/finish by checking the box on the first page and having them listed on the second page if checked, since it sounds like there's going to be some amount of personal discretion involved as opposed to a 100% rule based system.

Also maybe?

A small hard coded area might help, with an explanation.

Hard coding = manually enter the results you would expect in the sheet where you'd expect them, with the reasoning behind why it's there typed out as well. Reason being, it may make perfect sense to you why a certain item would be there and not another, but to me it's a guessing game until I see the rules laid out.

mew!

Either of the first two suggestions would work (Except, they would be games I own, since a backlog is my "list of shame" of games I bought and never beat, that I need to get to eventually--but probably never)

I wouldn't mind handpicking the entries, and that would put me in more control over what appears. I just don't know how to execute it.

However... I've tried using checkboxes before, but it seemed to be too much trouble! Maybe I was doing it wrong... The checkboxes didn't work well with adding new entries, as dragboxing them just copied the same cell links instead of making them a series. They just didn't seem like they were working with the worksheet... If that makes since.

I also tried using a macro to automatically make a checkbox for each cell in a column linked to that cell, but it still was a lot of trouble.

Awesome, thanks!

As long as it won't conflict with adding new entries? Let me know what's been done too, so I can learn it. =)

Wow, thanks a million! I'll look at it in a bit. I really really appreciate it!

I hope to help someone here like you helped me.

I'll keep you in mind if I have a question. =)

looks great!

what's the edit for again?