Choose drop down menu to pull put 2 columns from master data

  • Hi,
    I would like to pull out data automatically in Column A and Column B both by looking at another sheet , in my case"Coding 2" I would like meeting name in the B column.


    Have attached my excel spread sheet.


    At the moment, I can only have it in Column A with this code.




    Thank you


    Moderator Comment: Please use code tags. I have added them for you today.

  • Re: Choose drop down menu to pull put 2 columns from master data


    just change the code as below:


    Code
    If Target.Parent.Cells(65000, 1).End(xlUp).Row < 500 Then 'If there is still space in the table, add it to the last line
     Target.Parent.Cells(65000, 1).End(xlUp).Offset(1, 0).Value = c.Value
     Target.Parent.Cells(65000, 2).End(xlUp).Offset(1, 0).Value = Range("B1").Value

Participate now!

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