Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

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

  1. #1
    Join Date
    15th June 2017
    Posts
    5

    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 at 18:32. Reason: Delete

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th November 2006
    Posts
    1,578

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

    Hello,

    Attached is your workbook ...

    Hope this will help
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th June 2017
    Posts
    5

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    25th November 2006
    Posts
    1,578

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    15th June 2017
    Posts
    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!!!!

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    25th November 2006
    Posts
    1,578

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

    Glad you could fix your problem ...

    Thanks a lot ... for your thanks ...

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 3
    Last Post: April 11th, 2017, 18:07
  2. Replies: 6
    Last Post: March 2nd, 2015, 03:48
  3. Replies: 2
    Last Post: May 30th, 2013, 04:00
  4. Replies: 1
    Last Post: September 15th, 2010, 01:37
  5. Replies: 3
    Last Post: January 16th, 2007, 02:34

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno