VBA Autofill Last Row in range to the last Row in adjacent Column

Thanks in advance.
My Goals:

Works so far
1. Copy range, which is always the same: Range("AR1:BN1")
2. Paste into the last blank Row in Column P through AL

Can't get to work
3. Autofill the new Pasted Range down to the last cell with Data in Column O

The Last Blank Row in column P through AL will change
The Rows of data will continually be added to

The VBA I have so far for 1 and 2 is below. I have tried multiple different methods on these forums, which all seem very close, but just won't work for my changing data.
I commented the last 2 rows because they were diving me errors, but that's as close as I've gotten so far.

Please Login or Register  to view this content.

Again, Thanks you so much!

Thank you so much for your time.

I want to copy the formulas from "AR1:BN1" to "P:AL" columns.
Your code only copied the values to P and Q and it didn't stop at the last row in O.

This code actually worked last night. It didn't use autofill, but it worked for me.
What worked:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)