delete info from source file w/out changing the destination file

Discussion in 'Microsoft Excel New Users' started by TB, May 26, 2008.

  1. TB

    TB Guest

    Hello
    I have two work sheet linked together for patient tracking files. All the
    information from the open source file is automatically updated in the Closed
    file. I want to be able to constantly update the closed file with out keeping
    more then 30 rows in the open file. Therefore, Once the patient tracking is
    completed, I should be able to delete the information form the source file
    with out removing it from the destination file. I am also having difficulty
    in moving the data down once I want to add another patient into the open
    file. e.g. row one was Tricia - info completed - delete Tricia info save in
    Closed file. New row one Pat - starts to over write Tricia or Trica's info is
    deleted because source file info has been deleted. Any advise welcome.
    --
    TB
     
    TB, May 26, 2008
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    3
    Views:
    215
  2. Bubey

    Change auto destination in Save As ???

    Bubey, Dec 19, 2006, in forum: Microsoft Excel New Users
    Replies:
    9
    Views:
    231
    Nick Hodge
    Dec 20, 2006
  3. billbob

    Paste data to cell and keep destination font and size

    billbob, Jul 10, 2009, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    276
    billbob
    Jul 10, 2009
  4. John
    Replies:
    1
    Views:
    667
    Gord Dibben
    Oct 25, 2009
  5. transkawa

    cannot paste source column width to destination column width

    transkawa, Oct 12, 2010, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    1,104
    James Ravenswood
    Oct 15, 2010
Loading...

Share This Page