| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sycronizing Ranges
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 -- Peter London, UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| Viewing List of Named Ranges | Excel Discussion (Misc queries) | |||
| Problem with graph ranges | Charts and Charting in Excel | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
