Copy / Append values of a named range from Workbook A Sheet1 to aclosed Workbook B Sheet1 in same folder
 

My range named X, only contains formulas
I need to copy / append values of this range to a closed destination workbook
in the same folder, which has the same number of columns and format as my named range.
Then, Save and Close the destination Workbook
and display message "Task Completed".
Thank you for your help.
J.P.