Hello,

This is my first time posting so I hope I can explain what I am trying to do clear enough, any question on clarification are welcome. Also I am very new to VBA so excuse anyignorance!

I have a summary workbook ("Summary.xlsm") which contains a data validation drop down in the worksheet "SummarySheet" in cell "F3". This contains a list of skill numbers.

I also have another 30 or so workbooks which contain multiple worksheets. I want to look in all of those workbooks in the worksheet "RESOURCES 2" and search for the selected skill number in the "Summary" workbook.

For each workbook, Once this skill number has been found I want to copy the range, starting with the cell that contains the skill number and then Selection.End(xlDown) and Selection.End(xlRight). Once copied I want to paste this on the next blank row within "Summary" workbook (First blank row will be on Row 7).

In Short..

- Select a SkillNumber in F3 of SummarySheet
- Select a directory folder with other workbooks in
- For each workbook in directory
- Find sheet: "RESOURCES 2"
- Search for selected SkillNumber
- Once found, select that cell, ctrl + shift + down selection and ctrl + shift + right selection
- Copy this range
- Paste back into main workbook ("Summary.xlsm"), in sheet "SummarySheet" starting on the next blank row
- Loop until all speadsheets have been done

Thank you very much for any help anyone can provide!