Hello,
I have defined several ranges with formula's in sheet2 eg:
range1=A1:D5 (5rows),
range2=A10:D20 (10rows),
range3=A30:D37 (7rows)

In sheet1:column A I have cell values
range2
range2
range1
range3,
etc

How can I insert the matching range defined in sheet2 into sheet1,