I need a VBA script which will read from a range of cells (D2:D40) in one workbook (A) and copy over the worksheets with the same names from Worksheet (B) to workbook A. I also need for the VBA to ask for the link to Worksheet (B) before running. is this possible?
Solved by O. J. in 18 mins