I would like to achieve the following using VBA:
Copy the named range (workbook level name = MyRange) of the worksheet named 'Data' to the worksheet named 'Results' with the following requirements...
.... Link the values
.... Start the pasting action on cell reference A5 of the 'Results' worksheet.
Help is much appreciated. Thank you very much in advance.