Hi again,

I've got an idea for the 'export' side of the problem. I've created another
worksheet for data collection where each cell equals one of the other
worksheet's 'input' cells. I'll then have a 'Save As .csv" routine run so
the data collection sheet will be saved. I'm working on building this now
and I don't think this step will be any problem.

However, I don't quite know how to go about populating the blank template
from one of the saved csv files. Any help is appreciated.

Thanks in Advance

"rpw" wrote:

Hi. I think this is possible, but I don't know how to go about it or where
exactly to look.

I have a multi-worksheet workbook that is around 2.4 mb in size. The user
inputs a relatively small amount of information on a few of the worksheets.
The rest of the worksheets hold fixed data used for performing various
calculations or building reports. For each separate use, the user is
performing a 'Save As'. I have one user who is creating up to 20 of these
files each day which is really filling up their hard-drive.

I'd like to have a solution to this problem and I'm guessing that if all of
the 'input' cells were to be exported to a comma delimited text file, the
text file would be very small in comparison. Likewise, if the text file were
imported, all of the calculations and print functions would still work
normally.

So, my question is: How do I go about this?

I'm sure the solution is VBA, but my VBA knowledge is very slim.

Any and all help is much appreciated. TIA :-)

--
rpw