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

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519671

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

--
Thanks for your time
Egglett


"davesexcel" wrote:


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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519671