We help IT Professionals succeed at work.

copy data to other sheet based on conditions

Medium Priority
Last Modified: 2012-05-11
I have this excel sheet which I'm attaching. In the first column I have some numbers and the 2nd column I have a yes/no value where yes is indicated by a value of '1'. I wish to copy the values from the 1st column when the row of the 2nd column equals '1'. How do I do this? I guess with some vb script?

Can someone give me some code in vb because I'd like to learn it too?

If there is an easier way as well can you please show it to me?

Thank you,
Victor copy-data-to-other-sheet.xls
Watch Question

Where do you want to copy the values TO?
Unlock this solution and get a sample of our free trial.
(No credit card required)
Victor KimuraSEO, Web Developer


Thank you. Works nice.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.