Updating from external file & keeping previous data static
From: Mildred (starmyr_at_hotmail.com)
Date: 04/12/04
- Next message: Mildred: "ASAP Utilities - free!!"
- Previous message: Maurizio Borrelli: "Re: "Rounding" error"
- Next in thread: Vasant Nanavati: "Re: Updating from external file & keeping previous data static"
- Reply: Vasant Nanavati: "Re: Updating from external file & keeping previous data static"
- Reply: Bob Phillips: "Re: Updating from external file & keeping previous data static"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Mildred: "ASAP Utilities - free!!"
- Previous message: Maurizio Borrelli: "Re: "Rounding" error"
- Next in thread: Vasant Nanavati: "Re: Updating from external file & keeping previous data static"
- Reply: Vasant Nanavati: "Re: Updating from external file & keeping previous data static"
- Reply: Bob Phillips: "Re: Updating from external file & keeping previous data static"
- Messages sorted by: [ date ] [ thread ]