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