i need a code,
1- ... prompts the user to open an excel file (source file)
2-... copies the data from Range(D3:E9999) of the first worksheet of the source file
3- ... pastes this data into Range(A9:B9999) the first worksheet of the currently active workbook (target file)
4- If there ise data in Range(A9:B9999), pastes copied data into Range(C9:D99999)
5-If there ise data in Range(C9:D9999) too, pastes copied data into Range(E9:F99999)
Thank you very much for your great and professional help.