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
Bookmarks