Hi Folks!

I need to create a macro for my work and I have been trying all day t
do it without success. None of my workmates can offer a bette
solution.

The problem: I have been asked to write a macro which will filter ou
approximately 160 reference numbers from a list of approximately 500.

It takes the following structu

Scheme No Area Dept Person
9876gf34 A G.P.P D Smith
9898gf54 B M.P.U T Jones

I receive a different spreadsheet every week with 500 numbers. I need
macro that when activated will filter out the 160 relevent numbers an
paste them in a seperate sheet (possibly sheet 2). I have attempte
doing a macro with the autofilter. However, it only works if th
numbers are in a given order (if the numbers are jumbles up it doesn'
work). The filter only needs to work on the A Column (i.e. Scheme No
and all the other relvent information shouls be copied according to th
Scheme No.

I seem to have rambled on somewhat! I hope someone can help in som
way!

Thank You

Mar

--
Message posted from http://www.ExcelForum.com