Look at the Change event if the change will be made manually or the
calculate event if the value will change based on a formula.

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

for vba tutorials, see links at David McRitchie's site:

http://www.mvps.org/dmcritchie/excel....htm#tutorials

the VBA tutorials are after the Excel tutorials.

--
Regards,
Tom Ogilvy



"R Storey" <R wrote in message
...
I do not know much about visual basic, but I have a spreadsheet that, in
column E, there are 5 different options. I would like to put these into 5
different worksheets, and then have a macro so that if the value changes,
the
whole row automatically moves into the correct worksheet.

Does anyone know if this is possible and how it can be done?