Formula for Deleting Text based on Criteria

Does anyone know if there's a way to have text on one sheet automatically removed/deleted/hidden based on data/criteria entered on another sheet in the same workbook?

For example, in my attached worksheet I have three sheets (Draft Board, OVR and C). All three sheets have a list of names, I would like the 'OVR' and 'C' sheets to have names and all the data in that row with the name removed/deleted when a value is entered with that same name on the Draft Board sheet.

Let's say I enter a number value in cell I4 of the Draft Board Sheet for the name Buster Posey, I would then want the name Buster Posey and all his information in that corresponding row removed/hidden automatically from the 'OVR' and 'C' sheets. In addition, once the value is then removed from cell I4, the player would then reappear. Is this possible?

My worksheet is attached, any help would be greatly appreciated. Thanks!

Originally Posted by GC Excel

Hello,

hmmm. I believe I answered the same question yesterday...
http://www.excelforum.com/excel-form...ml#post3974149

Did you try to modify the code I provided?

Yes I replied with a question but never heard back figured you were busy, sorry sort of on a deadline with this project.

Originally Posted by GC Excel

Hi again,
From the file you sent me, try this new code :

Please Login or Register  to view this content.

Yes it works now, but it seems to take about 30 seconds to take effect, I need it to be much faster than that, is that because of the size of my file? How fast did it work for you?