please help - I am doing a rostering spreadsheet.
sorry if I don't explain it well what I would like to do.

1. I would like to put a person's name ( andrew, tim etc ) in a particular cell (eg. A1 )
2. Depending on the name placed into A1 I would like another cell (eg. C2) to have automatically have placed another word (eg. cleaning, restocking, etc )

Is this a macro visual basic, I am not verse with this, could some-one help

many thanks

andrewm