Victor Kimura
asked on
copy data to other sheet based on conditions
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
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
Where do you want to copy the values TO?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. Works nice.