form filler that seraches a separate workbook for data and emails answer

[Blanchetdb]

Hi,

I require assistance with the following

On Sheet 1, the person completes a form (each cell contains a drop down menu) - once the form is completed they press "SUBMIT"

a search is done on a separate workbook based on the info provided on the form - answers are emailed to the requestor

example:

Cell D15 - (Branch)Operations, D17 - (City) Calgary, D13 - (Group/Level)AS02......

a search is conducted in a separate workbook (Staffing process Workbook) that has columns named Branch - City - Group/Level

if ALL condition are met, an email is sent, to the requestor that contains information in Column A of the Staffing process Workbook

any help would be appreciated

 

[James006]

Hi,

As an initial step ... you could test the first phase ...

Sub TestOpenWbk()
Dim wbk1 As Workbook
Dim wbk2 As Workbook
Application.ScreenUpdating = False


Set wbk1 = ActiveWorkbook
Workbooks.Open Filename:=ThisWorkbook.Path & "\YourStaffingNameFile.xls"
Set wbk2 = ActiveWorkbook
''''''''''''''''''''''''''''''''''''''
' Insert the tasks to be performed ...
''''''''''''''''''''''''''''''''''''''
Application.ScreenUpdating = True
End Sub

Hope this will help