P
Peter
sIn A1.C10 I have data imported (via MS Query) from an external source. In
D1.F50 I have cells that refer to A1.C10. My problem is that if my import
expands from A1.C10 to (say) A1.C20 the range D1.F50 is also shifted when I
want it to remain fixed. How can I fix D1.F50 in place so it picks up the
right row in A.C whatever they expand to.
Many thanks
D1.F50 I have cells that refer to A1.C10. My problem is that if my import
expands from A1.C10 to (say) A1.C20 the range D1.F50 is also shifted when I
want it to remain fixed. How can I fix D1.F50 in place so it picks up the
right row in A.C whatever they expand to.
Many thanks