Hello,
I need to create a macro that copy a range of cells in a workbook and paste the copied values in another workbook with the name based on the values of one cell. The range that should be copied is of the sheet 1 of the workbook 1, from cell A5 till last blank cell in column L (A5:L?), and the values of this range should be pasted in a new workbook in the cell A2 to the column L, that appears already with the name of the cell P2 of the sheet1 of the workbook 1 (but with the option of save the file onn the location that the user wants to save the new workbook). Is this possible? Please if someone can help I will be very grateful because I am new at macros creation.
Thanks in advanced
Bookmarks