Hello All,

Any help with this would be awesome.

I have a workbook that is used as a request form for data named requestform.xlsx. The request form workbook consists of Sheet1 of having the user input a asset number into cell A2. The user will also select from a dropdown box in cell F2 a site corresponding to what site product the asset number is at. Once the user inputs these two peices of information, I am trying to come up with a macro that goes to a totally separate workbook named locations.xlsx with 7 different sheets of data for each site. So for example,

The user in A2 inputs an asset number say 453124 and selects in the dropdown box site 55 into Sheet1 of requestform.xlsx.

The macro then will need to access the workbook named locations.xlsx with the 7 different site sheets and go to site 55 sheet and search for asset number 453124 and copy that data in the row which is related to asset number 453124 to Sheet3 in the requestform.xlsx workbook.

If I could get help with this, it would be very much appreciated.

-A.S.