Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter question | Excel Discussion (Misc queries) | |||
Filter question | Excel Discussion (Misc queries) | |||
Another Filter Question | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
filter question | Excel Discussion (Misc queries) |