Hi,
I have a workbook with various sheets. First sheet of my current workbook is "StartData". I have more data files with a sheet name "EndData".
I want to copy data from Range B5:BP250 of Sheet "EndData" of any closed workbook. (User will select which file to get data from). The data need to be pasted in the current work book in the sheet "StartData" in B5:BP250

Thanks in advance.