I have data in sheet1 of workbook named test.xlsx.
I need to copy the data in sheet1 of test.xlsx from A4:G4 to end and paste in sheet2 of workbook named sample.xlsx.
I will be working in Sample.xlsx so i need the macro to copy from sheet1 of test.xlsx.
The macro should ask for the test.xlsx file location and user should select the file through Browse.
Once file test.xlsx is selected the said range of data should be copied and pasted in sheet2 range A3:G4 to end.
Please help.