Good morning (or afternoon, ooor evening),

First of all, sorry for my bad English. I am currently expecting 2 problems I need to solve in Excel 2010. The thing is, I am no way skilled in using VBA, that's why I have to rely on my basic Excel skills. To make it short:

1. I need to set, that the content of a drop-down list depends on what is filled in a cell next to it. Here's the example: For a text "Cooking" (cell A1) is set a drop-down list containing "Spaghetti", "Fish'N'Chips", "Rizzoto" (A2), and for a text "House Cleaning" (A1) drop-down list "Vacuuming", "Dirt Cleaning", "Dish Washing" (A2). Shortly, I need to make variable drop-down list in one Excel sheet (I'd like to avoid using more than one). Any way to do it?

2. Is there a way to automatically fill a cell with a static (!) date and a static (!) time (separately in 2 cells) in case one cell contains a text? Example: There are 3 empty cells - B1, B2, B3. I case I fill in cell B3, there will be shown static date in B1 and static time in B2. In case I remove the text in B3, both date and time will be deleted. I tried TODAY and NOW functions, but both are not static.

I hope that you'll understand what I wanted to say, and thank you in advance for a help solving these problems. If something is not understandable, let me know, and I'll try to describe it more accurately.