Define variable range as named range

Hi as the last step in a process which has been invaluably helped along by this forum, the last step is to finish the macro with defining a named range for the data which has just been sorted. It needs to be variable to cope with any additions to the initial data. The attached code selects the data from named ranges and copies them to Sheet2. It then selects the present data and sorts by columnA. The step I need is to name this range as MOT_DATA. I tried recording the action and using the code but got lost when cell references changed to R1:C1(not used to this). Any help appreciated. TA Nigel

Please Login or Register  to view this content.

Here is a simpler way to name a range:

Please Login or Register  to view this content.

Works a dream and means I can link important data per vehicle. Many thanks for your help.