Updating from external file & keeping previous data static

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mildred (starmyr_at_hotmail.com)
Date: 04/12/04


Date: 11 Apr 2004 20:49:05 -0700

I am currently updating a series of Excel sheets which change daily.
I set it up so that it has references to the source file and once I
replace the source file with the new data, then the sheets get
updated. I have been asked to keep the data from previous week "as
is" and just append the new data each and every day. I have to copy
and paste the information to the ***, but because the cells are not
continous, I spend hours in this process. Do any of you have any idea
as to how I could possibly add some sort of automation to this
process?

Thank you,
Mildred


Quantcast