Move entire row of data from open to closed file by entering date
 

Hello - I am having problems transfering data from a open file to a closed
file by entering a closed date. This spread sheet contains customer
information with 30 rows and several columns. I have it set up that all the
information entered automatically links to the closed file. However, I am
trying to get the entire row to disappear from the open file and display only
in the closed file once a closed date is entered. The closed file should be
able to continiously archive all rows added from the open file. The open file
should still be able to link information to the closed file in row 1,2 etc,
and all the columns with out over writing any of the previously transfered
and saved data. Any help will be appreciated.