Hello,
I would like some help regarding the following:
I have a sheet call "PO_Status" which has several columns, I need to copy columns based on certain text (Active) in column F and multiple text in column D (Network, Server, Rack.ect...)
I want the condition to met as following :
IF column F has text (Active) and any of texts in column D then will be copied to an other sheet call Active_sheet.
I have the following code which is not working good.
Please Login or Register to view this content.
you should be posting this in VBA section not general section
why you using Row if you want to copy column?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hello humdingaling,
Sorry did not see the VBA section, I hope mod can move it.
I am using rows because I am interests to copy the rows. Not the columns. I see your point and I hope there is a better code, as the loop for mine is too long.
can you provide sample data sheet so i dont have to data entry to replicate
also which bit is actually not "working good"?
is the if statement not working?
attached is a sample data
The IF Statement does not work correctly it would not look for all the condition... main thing here is to have IF "Active" and any other words from column D I specify meet then will copy the rows to other sheet.
Thx
Don't think you can use OR the way you are using itPlease Login or Register to view this content.
also INSTR function as you are not doing exact match
if string exist it would give a number so if number is greater than 0 then if loop is executed
i separated your "active" loop so make it easier to follow
Last edited by humdingaling; 06-18-2013 at 11:42 PM.
This work nice. However, is there any way we can make it case- sensitive or exact match, for example: if I have "Server" and other Cell has "Server 1" it will pull both rows while I am only calling for cell with exact "Server"
this line will pick up if cell contains "network"Please Login or Register to view this content.
is equal to "Server" ie server 1 is skipped
or contains "rack"
reason i used instr is because in your example you wanted Network to be picked up but in the cell it is network devices
i assumed there was other cells network "BLAH"
Thank you very much for your help, this is just a small part of a long code. I only used
Thank you again, I owe you a beerPlease Login or Register to view this content.
not a problem, well you know how to use instr now if you should need it
glad to help
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
done,
Thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks