Hi guys, I was wondering if any of you can help with a spreadsheet I'm trying to build. This is actually a couple of smaller problems in one. I'll break it down.

Background: I'm using Excel 2003 on Win XP. I have six columns, A to F, which hold the following titles respectively: Type, Date, Status, Issue, Category, Date Completed.

1. Once I enter an issue into a new row in Column D which can be any value or a number, I would like columns A (type) and E (category) prepopulated with a set value (the same value each time) but which I can change if necessary.

2. At the same time, I would like today's date entered into column B (date).

3. Column C (status) can have lots of values but once the value is set to Done then column f (Date completed) should be prepopulated with todays date.


Once the date is set then obviously it shouldn't change so should be stamped rather than a formula. I've tried a mixture of vlookups and macros but haven't made much progress. If anyone can help with any of those parts or even the whole thing then that would be awesome. I have some macro writing experience but this is proving to be beyond me.

Thanks in advance all.
~Z