Delete all rows in workbook with same title

[dbe89]

Hello all! I'm working on a personal cheat sheet to use for fantasy football. Currently, I've got data in 5 sheets (QB, RB, WR, TE, ALL). The data includes info and projected stats like Player, Team, Rushes, Rush Yards, Rush TDs, Fumbles, Average Draft Position, Tier, etc. I'm going to have each sheet sortable by stat. If anyone is familiar with a fantasy football draft, there's a bit of a time crunch. I'd like to be able to enter a player's name in an input box and delete/hide that player's information from both the position sheet and the overall sheet at the same time. That would be the easiest way of keeping only the information of available players visible and sortable in my cheat sheet. I'm sure I'll have more issues along the way but first things first. Thanks!

[FDibbins]

Administrative Note:
•We would love to help you with your query, but first, before we can proceed…
•Please see Forum Rule #1 about proper thread titles and adjust accordingly...To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

[Cogito13]

Can you post a sample workbook? I can look into creating a userform for you.

[dbe89]

Attached is a simplified version of what I'm working on. What I'd like to be able to do, which probably isn't possible, is type a player's name in the draft board on the first sheet, and have it automatically hide that player's stats from both the position and overall sheets. For example, if Adrian Peterson is drafted first overall, upon entering his name in B4 on 'Draft' row 2 on both 'RB' and "Overall' would become hidden. I'd still want to be able to sort those tables though, if that makes a difference. Please let me know if this is possible or just a dream! Thanks!