Hi Mark,

Am Fri, 11 Aug 2017 04:34:30 -0700 (PDT) schrieb Living the Dream:

This worked well for the first row, sadly every row down has the same exact formula instead of incrementing the row number as it goes down the list.

all relative references will increment for each row. Only the absolute
references stay.
Download here the demo workbook because macros are disabled in OneDrive:
https://1drv.ms/x/s!AqMiGBK2qniTgaAyDPnqcQyQIjJxpA
There are solution for both your questions.

Regards
Claus B.
--
Windows10
Office 2016