Thanks to all who have been providing code and Joe for his videos and help with array formulas.
In the end, none of these solutions were working for me, but this did. Simply converting the
sheet to a table. Suddenly all formulas and formatting copy down by default. Here is a youtube
video with directions. May not work for everyone, but it was my solution.
Thanks,
Simon