HELP with Sormula to move data

E

Egglett

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?
 
D

davesexcel

Have you tried the filter
select the range you want to filter,
goto
Data => filter
now in the columns there will be arrows, click one of the arrows and
and make a selection, only the data you requested shows up
 
E

Egglett

Thanks Dave... tsk - why didnt I think of that!!
It worked a treat - was able to get my macro to add a new row at the top,
filter out "Monthly" and then cut and paste into a new worksheet....ta daaa
exactly what I wanted

Brill
 
Top