I have a list of newsagents who either pay "monthly" or "weekly". At the
minute they are all listed in the same spreadsheet

I want to create a macro to identify the "weekly" only and delete the
rest...or move "weekly" to a new page with the rest of the info in other
columns (eg newsagent name - address - etc)

I have looked at "Find" but dont think this is suitable...I think I need a
formula that finds all "weekly" and picks up and moves

HELP!!

Any ideas?

--
Thanks for your time
Egglett