Please Help

  • Thread starter Thread starter Marcopolo
  • Start date Start date
M

Marcopolo

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 structure:

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
 
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 structure:

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
Click to expand...
How do you tell which numbers are relevant and which
aren't?
 
Back
Top