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.