Copying a formula down to the last active cell starting from the last populated cell

If i understood you correctly, you mean you would want to copy down the formula in column A from row 2 to the last populated row in your file?

Which is the column that has the last populated row?

This is the code:

Please Login or Register  to view this content.

but the autofill will only work one cell at a time, i want it to go down to the last active cell, as if i were double clicking it to drag it to the finish

Thanks in advance for your help!!

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Maybe i can help you re-structure the code. Can you please attach a sample file showing how the raw data (sample data) looks like before you do the text to columns?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.