I have a file with 4 columns in sheet1. Name-Town-Job-Type. There are 4
possible entries for "Town". If the town entry in sheet one is "X", I want
that entire row to be copied to sheet2, If"Y" to sheet 3. If "z" to sheet4.
If "ZZ" to sheet 5.
Can this be done?
Any help appreciated
--
John