vba filter question
 

Hi again,
so I have a sheet with a lot of data on it that I do not need. Ther
are only two pieces of info in each section that I need. My question i
how would I write a vba filter (or copy the data to another sheet) an
keep it all in the same order, this is crucial. The first part of eac
sections info is related to the second part of info in the section an
so has to stay together.
The trick part is that the first part are random agents names, th
second section is their time.
Anyone know how to extract this with vba?
The second part od this problem is that the agents names are usin
different spellings on different reports, I am thinking that due t
this part not changing too often I can make one name be equal to th
other name and so when I do a Vlookup I will find the agents name o
the other report, is there any other way of doing this?
All help very welcome
Patric

--
crowdx4
-----------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57403

vba filter question
 

Range("B9").Resize(10,3).copy Worksheets(2).Range("A1")
Range("B30").Resize(10,3).Copy Worksheets(2).Range("A12")

--
Regards,
Tom Ogilvy


"crowdx42" wrote in
message ...

Hi again,
so I have a sheet with a lot of data on it that I do not need. There
are only two pieces of info in each section that I need. My question is
how would I write a vba filter (or copy the data to another sheet) and
keep it all in the same order, this is crucial. The first part of each
sections info is related to the second part of info in the section and
so has to stay together.
The trick part is that the first part are random agents names, the
second section is their time.
Anyone know how to extract this with vba?
The second part od this problem is that the agents names are using
different spellings on different reports, I am thinking that due to
this part not changing too often I can make one name be equal to the
other name and so when I do a Vlookup I will find the agents name on
the other report, is there any other way of doing this?
All help very welcome
Patrick


--
crowdx42
------------------------------------------------------------------------
crowdx42's Profile:
http://www.excelforum.com/member.php...o&userid=37749
View this thread: http://www.excelforum.com/showthread...hreadid=574033

vba filter question
 

Ok, so all I am getting from the posted response is that it selects
range and copies it over into a different column?
Was this a response to my question?
My main issue is the filtering out of the data in my worksheet with th
fact that the names are variable.
If this is a response to my question, could you elaborate?
Thanks
Patric

--
crowdx4
-----------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57403