Help-I need Excel help

[KatyMac]

I have a column of merged cells

I want to put
=d4
=d5
=d6
in each of them

But because they are merged I am getting
=d4
=d7
=d10

I have to do this over & over again is there a quick way to cheat or copy & paste?

I tried copying formula but it didn't work

bump

Does Ctrl-D work? Select the cells you want to copy to, with the first cell containing the formula you want to copy, and press Ctrl-D. Tbh I don't know if that will work but it sometimes solves tricky copying issues for me. (Ctrl-R does similar for copying across).

Nope, sorry

I still get the
=d4
=d7
=d10

you can do it with a concatenate and indirect
If you create a list of 4,5,6,7 etc in the usual way, somewere else, then I think it's something like =indirect("concatenate(d", ,")")
Then copy that down to all the cells so it picks up the 4,5,6 etc

Will probably need some fiddling with though, sorry

I've been playing with that & it's almost as much work......

Gosh I am lazy sorry - thanks for helping

Might be too late now, but for the first one (=D4) use:
=INDIRECT("D"&CEILING(ROW(A1)/3)+3)
Then copy that down your merged cells.
Hope that helps!

Thanks I had a brainwave and made it one cell & unmerged it all (iyswim)

But thank you all