Drag and Drop into an input range results in #REF! error
Hi all,
I have worksheet with an input range of, for example, N2:O2. There are a number of formulas in adjacent cells that reference N2 and O2. The formulas work fine when the entries are input via Ctrl+V or manually typed in.
To speed things up, since the input data is another area in the same worksheet, I'd like to enable the users to simply drag and drop into N2 and O2, however, the formulas error
out immediately with #REF! since perhaps the relative references appear to have been impacted.
I've tried changing the formulas to absolutes but that had no positive impact.
Any ideas? Many thanks!
|