I would like to set up in my PERSONAL.xls file a macro which covers the following macro.
1-Display an inputbox which says: “From which Range do you want to copy the data related to your ActiveSheet”
If I enter A6 the macro should copy from A6 to the last used range cell. If I don't enter data stop the program and display a message “The range reported is not valid”.
2-If 1 is ok, display an input box: “In which Workbook do you want to paste the copied data ?”
I will need to enter the name of the workbook (with the extension OR NOT). Then if I validate and the workbook reported is not opened stop the program and display an error message ("The workbook reported "" is not opened unable to copy the data"
3-If 2 is ok, display an Input box: “In which Worksheet do you want to copy the data3,
If I don't enter any value and I validate the inputbox, the sheet from which I have made the copy should be added in my destination workbook else If I specified a worksheet check if it exists if so paste the data in A1 if not display an error message the worksheet specified doesn't exist and stop the program