Question about multiple data sources
 

I have a spreadsheet which I am pretty much finished with as far as the cell
formulas are concerned, but now there has been a wrench thrown in the works.
I have a pretty simple data set that my calculations are based on. Column A
is date, B is temperature, C is humidity, and D is pressure. The
calculations are all based on these 4 criteria. My problem is that now I am
faced with about 30 data sets to run these calcs for. They are all in CSV
files which I can use as is, or convert to XLS files.

My question is: is there a way to use the main spreadsheet with all the
calculations and "call" one of the data sets in to the main spreadsheet? I
don't know if a pivot table would do this or not, as I haven't done much
with them, but I can learn. I want to be able to basically pick one of the
data sets, run the macro to do the calculations, and then save the output as
a web page. All the data calculations end up on one sheet for each data set.
Having all of the data sets in one spreadsheet probably isn't a good option
either. These data sets are up to 5000 rows, but at the most 4 columns.

Any help is appreciated.

Chris

Question about multiple data sources
 

Hi,
Please send your file to me and I may be able to create a
utility to process the data.



- Mark
See my other stuff at:
http://www.geocities.com/excelmarksway

-----Original Message-----
I have a spreadsheet which I am pretty much finished with
as far as the cell
formulas are concerned, but now there has been a wrench
thrown in the works.
I have a pretty simple data set that my calculations are
based on. Column A
is date, B is temperature, C is humidity, and D is
pressure. The
calculations are all based on these 4 criteria. My
problem is that now I am
faced with about 30 data sets to run these calcs for.
They are all in CSV
files which I can use as is, or convert to XLS files.

My question is: is there a way to use the main
spreadsheet with all the
calculations and "call" one of the data sets in to the
main spreadsheet? I
don't know if a pivot table would do this or not, as I
haven't done much
with them, but I can learn. I want to be able to
basically pick one of the
data sets, run the macro to do the calculations, and then
save the output as
a web page. All the data calculations end up on one sheet
for each data set.
Having all of the data sets in one spreadsheet probably
isn't a good option
either. These data sets are up to 5000 rows, but at the
most 4 columns.

Any help is appreciated.

Chris


.