Move a row to a different worksheet if it a column contains a valu

[Guest]

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?

 

[Tom Ogilvy]

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/excel.htm#tutorials

the VBA tutorials are after the Excel tutorials.