AutoFill to Last Row in Column A

Hello, I thought I would do a screen-capture of "dummy-data" to help in getting a solution.

The attached screen-capture shows the end-result:

Where the user made multiple selection of data on the worksheet: Data

and the macro then:

Copied 'n' pasted the selected multiple data into the worksheet: Data to Text.

A new column was inserted in column A.

We manually entered the numbers 1, 2, & 3 in column A.

We need to AutoFill column A to the last row in worksheet: Data to Text.

Hope this helps,

Kind regards,

Chris