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?

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?