Greetings all!
I am running Excel 2000 on a Windows XP Pro machine. I have two
workbooks. Each row in either workbook is a description of a document
with a date by which a review of that document is due (among other
things) and, in workbook1, a date by which the final review of the
document is due. This date is in the last cell of the row, and is
calculated using a formula.
If the document is *not* reviewed by the final review date, the row with
the document's entry is cut from workbook1 and pasted into workbook2.
The only difference between the two workbooks is that the last cell in
the row from workbook1 doesn't appear in workbook2.
The employee, who shall remain nameless, who cuts and pastes has, in the
past, selected cells in the row up to, but not including, the last cell
in workbook1 before pasting the data into workbook2. Then the employee
deletes the contents of the last cell that was left behind, and deletes
the empty row. What we have discovered is that Excel is creating an
automatic link between workbook1 and workbook2 when we go through this
process. We don't want that.
Is the best answer the obvious one, which I think is select the entire
row in workbook1, cut, and paste in workbook2, and ignore the last cell?
Or is it simply a matter of copying from workbook1, pasting in
workbook2, and *then* deleting the row in workbook1? Are there other
options? Is Excel *supposed* to be creating this link automatically? Can
I turn off automatic link generation?
Thanks,
Mike Bro.
Bookmarks