Hi All,
I have an excel file with bunch of data and in which column 17 will have values Yes or No. Now I need to process rows having values Yes and leave the rows having value No in column 17. What logic I can use to process only column with value Yes??
Thanks.
You can do it several ways depending on what you mean by "Process rows".
Process = remove rows to a separate sheet....
Use the Data > Filter on that dataset, filter that column for "YES" and all the other rows will be hidden. Now you can cut all the visible rows all at the same time and paste them on another sheet.
Process = do something to each row
A macro will need to be constructed to loop through each used cell in column 17 and "do your process" on that row, whatever that is.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks JBeaucaire.. Did as u explained and got the results
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks