VBA code rather than vlookup

[bhalbach]

I have a worksheet that I am using vlookup to return values from a table (in the same workbook) based on a value I select in a drop down box in the worksheet...I want to change this up to use VBA and have the tables in a separate workbook.

So essentially...
I select a dropdown box value from a list, this will trigger a search in a separate workbook sheet for the dropdown value. When the value is found I need it to return the data from multiple lines back to the same sheet that I selected from dropdown box.

 

[mumps]

We would need more information.
-What is the sheet name containing the drop down list and in which cell is the list?
-What is the name of the search workbook including the extension (xlsx, xlsm)?
-What is the name of the sheet that you want to search?
-Which lines do you want to return and where do you want them returned?

 

[bhalbach]

I have a worksheet that I am using vlookup to return values from a table (in the same workbook) based on a value I select in a drop down box in the worksheet...I want to change this up to use VBA and have the tables in a separate workbook.

So essentially...
I select a dropdown box value from a list, this will trigger a search in a separate workbook sheet for the dropdown value. When the value is found I need it to return the data from multiple lines back to the same sheet that I selected from dropdown box.

Hello Mumps...

What are the odds of you replying, you helped me build this workbook & VBA about 10 months ago.
I have to build the workbooks first...I am sure this can be done but I wanted to be sure.

Brent

 

[mumps]

OK. Just respond in this thread when you're ready to go.

 

[bhalbach]

Mumps,

Is there a way to have multiple independent worksheet frames within one worksheet that function independently?

 

[mumps]

I'm not sure what you mean. What are "independent worksheet frames"? Please explain in detail.

 

[bhalbach]

Similar to were inserting/embed an excel workbook to Microsoft word...you could use multiple worksheets within a worksheet and the function independently without affecting the others.

ie...1st worksheets has 15 lines and a 2nd worksheet beside it has 5 lines...the 1st worksheet grows to 20 lines, the 2nd worksheet stays at 5 lines but is not affected by the 1st expanding...like an independent window/frame

 

[mumps]

It depends on how the "1st worksheet" grows. You can easily insert more data in the cells manually but if you insert or delete rows, that would affect the entire sheet.