I have a worksheet (#1) that references another worksheet (#2) line by line
and copies select information into the sheet. When I delete lines in #1 the
#2 comes back with #REF! for the lines that I deleted in #1. Data in #2 is
imported into another application and the format is important.