I have D1:D26 with data in each cell. I have a range H10:H62 that has merged cells. H10:H11 is merged forming H10, H12:H13 is merged forming H12, and so on. If I put =D1 in H10, how can I drag that down so it doesnt skip cells. Meaning When I drag H10 to H12 (which is the next cell because of the merge) H12 has =D2 in it?