[RaceBannon]

I have tried referencing a single cell, but it doesn’t show the date in the merged cells, but I am going to try it again as a single cell reference

[RaceBannon]

folks, I got it!

I merged b5 through b8

I wanted those cells on all following cells to have the same data

by referencing b5 in each follow on merged cell group, I got what is in b5 through b8 to paste fine

so b42-b45 is good, so is b80 to b83, etc

thanks for the help!!

So, the freeper a few posts above, who told me to reference the top left cell as my reference cell and to call that cell in my equation
=b5
that worked great :)