Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Find a Row and return value in a certain column value.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Find a Row and return value in a certain column value.

    Hi,

    I need a vba code for this and i cant do it,

    I have 2 worksheets, and i was trying to find a row in the worksheet 2 based on a cell on the worksheet 1, and then return a value of a certain column that a i want to search for.

    I want to return the "Codigo Aluno" value of a certain "Nome" choosen in worksheet 1.

    Formulário Alunos2.xlsm

    Hope you can understand what i want.

    Many thanks.
    Last edited by Luis Silva; June 15th, 2017, 18:32. Reason: Delete

  • #2
    Re: Find a Row and return value in a certain column value.

    Hello,

    Attached is your workbook ...

    Hope this will help
    Attached Files
    To say "Thank You" for the help received ...Just click on the "Like" icon ...underneath ... ... in the bottom right corner ...

    Comment


    • #3
      Re: Find a Row and return value in a certain column value.

      Hi, it helped a bit, what i really need is a VBA code for that!

      But thanks for that!

      Comment


      • #4
        Re: Find a Row and return value in a certain column value.

        Hello again,

        Sorry I did see you needed a VBA solution ...

        Attached is your workbook ... with an event macro ...

        Just by changing your selection in cell A5 ... your fields do get updated ...

        Hope this will help
        Attached Files
        To say "Thank You" for the help received ...Just click on the "Like" icon ...underneath ... ... in the bottom right corner ...

        Comment


        • #5
          Re: Find a Row and return value in a certain column value.

          Hi again,

          That helped a lot!!

          Thank you very much and many thanks!!!!

          Comment


          • #6
            Re: Find a Row and return value in a certain column value.

            Glad you could fix your problem ...

            Thanks a lot ... for your thanks ...
            To say "Thank You" for the help received ...Just click on the "Like" icon ...underneath ... ... in the bottom right corner ...

            Comment

            Trending

            Collapse

            There are no results that meet this criteria.

            Working...
            X