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

Will you specify SchemeNo as input to filter those rows
with matching the scheme number? Will there be 2 or more
rows with same SchemeNo?

G
-----Original Message-----
Hi Folks!

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

The problem: I have been asked to write a macro which
will filter out
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 a
macro that when activated will filter out the 160
relevent numbers and
paste them in a seperate sheet (possibly sheet 2). I have
attempted
doing a macro with the autofilter. However, it only works
if the
numbers are in a given order (if the numbers are jumbles
up it doesn't
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 the
Scheme No.

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

Thank You

Marc


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

.

-----Original Message-----
Hi Folks!

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

The problem: I have been asked to write a macro which
will filter out
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 a
macro that when activated will filter out the 160
relevent numbers and
paste them in a seperate sheet (possibly sheet 2). I have
attempted
doing a macro with the autofilter. However, it only works
if the
numbers are in a given order (if the numbers are jumbles
up it doesn't
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 the
Scheme No.

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

Thank You

Marc


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

.

How do you tell which numbers are relevant and which
aren't?