In merged cells which include cell G4:
=INDIRECT("Sheet2!B" & INT(ROW()/4)+3)
copy down.
Or likewise with:
=OFFSET(Sheet2!$B$3,ROW()/4,0)
or:
=INDEX(Sheet2!$B$4:$B$8,ROW()/4)
In merged cells which include cell G4:
=INDIRECT("Sheet2!B" & INT(ROW()/4)+3)
copy down.
Or likewise with:
=OFFSET(Sheet2!$B$3,ROW()/4,0)
or:
=INDEX(Sheet2!$B$4:$B$8,ROW()/4)
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote