Nirbhay Sharma
New Member
Hi guys. I am new to Excel VBA and macros. I need some help and guidance to perform the following tasks:
1) Check if a column has values (text) lying with a provided set of values (text)
2) Populate a column indicating the same for every row (true/false)
3) after that i need to copy some specific columns for the rows where the value is "FALSE" to another sheet.
I have done the following so far.
- using the following formula to get true/false populated in cells
=SUMPRODUCT(COUNTIF(G2,"*"&$L$2:$L$5&"*"))>0
here G2 is the cell where the value is populated; L2-L5 is the range of set of values
now i need help to copy the specific columns (say column A,C,E,G) for the rows where there is a value false in column H (plz see sample)
also is it possible to convert all of this into a macro or vba script to make the process automated and more efficient? if yes, can you guys plz help?
thanks in advance
1) Check if a column has values (text) lying with a provided set of values (text)
2) Populate a column indicating the same for every row (true/false)
3) after that i need to copy some specific columns for the rows where the value is "FALSE" to another sheet.
I have done the following so far.
- using the following formula to get true/false populated in cells
=SUMPRODUCT(COUNTIF(G2,"*"&$L$2:$L$5&"*"))>0
here G2 is the cell where the value is populated; L2-L5 is the range of set of values
now i need help to copy the specific columns (say column A,C,E,G) for the rows where there is a value false in column H (plz see sample)
also is it possible to convert all of this into a macro or vba script to make the process automated and more efficient? if yes, can you guys plz help?
thanks in advance