Find Value & Copy It To Another Column

  • Hey, I was wondering, how does one go about finding a specific valuein a worksheet, then selecting the value in the next column, then pasting the value in a different worksheet?
    For example, I want to find a particular person's name in a worksheet, upon finding the name, I want to select the number associated with the person which is in the column to the left of the name. I then want to copy and paste the number in a different worksheet.

    Thank You

  • Re: Find Value, Select Value In Another Column, Then Paste That Value

    As your posting does not give specific details this is a general idea on how to do it if you want to use VBA code

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!