[2013, VBA] Use Multiple "Finds" to load data from another sheet

[OriginalCarey]

Hi guys

I'm having a stickler here. I've got a dashboard, and a dataroom (which holds the data), and on the Dashboard I've got 5 drop downs. I want I want is that when a drop down is selected, or changed, that VBA runs a MULTIPLE Find within the Dataroom sheet to load in data (only certain columns).

This will be loading a possible multiple lines of data.

Ive used FIND before within the same system within a userform setting to load data into a Userform using the following code:

   Dim vreg As String, drow As Integer, c As Range
   Let vreg = IAGSelect.Value
   With Sheets("DataRoom").Range("a:a")
      Set c = .Find(vreg, LookIn:=xlValues, LookAt:=xlWhole)
      If Not c Is Nothing Then
         Let drow = c.Row
      End If
   End With
   
'// Load in REQUESTIONER DETAILS\\'

Let Me.txtReqName.Value = Sheets("DataRoom").Cells(drow, 2).Value

And was wondering if this could be used (advanced) to load in multiple values within a sheet.

Named ranges aren't really a matter, and if you could use just the 'change to find 1 that'd be great.

Anything, ANYTHING would be great. I'm thinking an array would work and loop it through, but can't really (if Im honest) waste more time trying this out as I'm on a deadline to code up some other parts of the System.

Cheers in advance

 

[Akuini]

I'm not sure I can help you, but it is better if you can upload your workbook (without sensitive data) somewhere (probably dropbox). It is easier to find a solution when the real samples are provided, so there will be more people here are keen to help you. And it may be necessary to include in the workbook what kind of results you expect.