Insert a YES in Column D if anything is placed in Column F?

I am trying to shorten my work time, and ensure that I don't forget to enter data into a spreadsheet I'm working, and I'm hoping someone will lend a quick hand to assist me.

I have a 6200 line sheet, and I have to find data in it, copy 2 contiguous cells (an ISBN number and the Description of that Number) and paste it in a row that the product has a relationship with/to... if I paste a value in the cells (let's say column D and E), I want the cell in Column B (in that row) to automatically insert "No". this isn't too difficult is it? I am using Excel 2007 or Excel 2008.
Additionally, but probably identical in the phrasing; When I determine a product is Original (meaning having no relationships data to add to columns D and E in this example), and I type YES into Column B, I want the corresponding cells in rows T, U, and W to insert a No.

Can you help me Please??!?

So, let me give a little more detail, if you don't mind. Thank you, anyone who is willing to lend me their expertise.

My 6311 rows contain products that are all pieces of a specific Program- for example, I am currently working a Reading K-6 series. I have to determine relationships between these products, either deeming the book an Original Product (which is one of my requests), or Not Original (and herein lay the other requests), which requires me to find the derivatives.
I have to go through every one of the 6311 rows, and either mark it Original (column 25) Or Not Original (still column 25) and paste the ISBN into column 28
1. When I determine a product is Original, it therefore necessarily follows that the product is NOT a Translation (Column 108), NOT a State-Specific Customization Column 109), and NOT a Copyright Update (Column 111), So, when I type YES into the cell in Row 466 Column 25, I want the cells in Row 466 Columns 108, 109, and 111 to Populate with No.
2. When I paste the ISBN into the cell in column 28, I am stating that this product is not original, so I want Column 25 to populate with "NO", and in column 30, I need to populate with either "Derivative", or "SE/TE Common Spec". If I find where to enter the formula, I could do all of the Derivatives first, then edit the formula, putting the "TE/SE Common Spec" in there as the rule, although if, after I paste data into column 28, column 25 populated with NO, and the two options pop up and I could choose 1 or the other (is a 1-click choice available??, rather than, click to choose the answer and click to enter), then this would be phenomenal and phenomenally appreciated.
3. I was making a little progress on getting column 25 to populate with NO when I put data in column 25, but If I determined I placed data in the wrong row, or pasted the wrong ISBN, and deleted what I put, or if I had a Yes in column 25, and I deleted it, then the formula on that line disappears; is there a way to ensure the formula doesn't disappear if i delete, re-add, or append the data I've entered in a cell that has a formula attached?

I really am hopeful that someone would like to help me; I am so close to feeling like I know a few advanced Excel things, and I don't want to be reliant on Excel Forum, and With such a huge Spreadsheet, I need to get some tricks to help me with my work, and again, I am thankful for your help.

If the Product is Original, Yes (entered manually) will be put into Col 25, and no ISBN numbers would go in 28 and therefore the SE/TE Common Spec or Derivative in 30 would be obsolete. 108,109, and 111 would get a No, but those 3 columns are going to have either a yes or no in them when it's all said and done, but they can stay blank until I populate them..

ExcelForumExample.xls
Here is a little example; I sure hope I uploaded it correctly.

so, when i type YES into one cell (I've labeled this on the example), I want 3 cells to populate with No.
But when I paste data into two other cells, I want that first cell to populate with No, and I'd love a choose box with two options to appear.

One of my issues is that when I do finally figure out how to enter a function/formula, every time I delete data from those cells (due to some error), the function/formula disappears,and I'd like the functions I've entered to still perform.

Thank you in advance!!

xladept; That worked fine; Yesterday I had Excel 2008, and I couldn't open it with the Macros (something about no Macros for Mac Excel 2008? has that been changed for 2011 version?) but I got 2011 today and opened it up, and everything seemed to work just fine. Thank you so much.

Anyone know some of the better enhancements for 2011? I see at first glance the sorting is upgraded. Any differences with some of the functions I use most- Auto-Filter( I see filters have been upgraded), Copy/Paste functions, Paste Special/f5 Visible Cells Only ??? I really wish I didn't have to go three menus down to hit visible cells only when trying to paste to a range that I highlight; I feel it should be presumed Visible Cells only... if I want data in a cell, I won't hide it, ya know?
Anyway; thank you all SOOO much.