Excel 2003 Data Linking from another Excel file question

By michaelc ·
Hi everyone,

I have 2 excel files, the source (data file), and the destination (printable label).

On the destination file, in a cell I have placed in the formula:


The data shows up perfectly on screen. However, as soon as I delete the Row 2 in the source, the destination becomes:


The reason I deleted Row 2 in the source is so that I can move the data in source up one row and let the next row be my next set of data for the destination.

Is there a way to keep the formula to always reference the source cells?



This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums