Hello,
I would ask about an issue probably faced many of you before. I
have a complex sheet of formulas that should be applied for different input data. The length of the input data is 4 columns and 13300 rows (30 years daily weather data). I have different input data gained from 10 different stations. The formulas will be developed and modified in time. Currently, I am looking for a solution to create a master sheet, in which I can put in data of different cases while at the same time I can modify the formulas themselves in the master sheet if it is necessary. Please consider that I need the results of these calculations continually summed up, maintained and updated in another workbook. With this I would like to save time of repeating the same formula alterations through several files (each one belonging to a weather station). Because of the file size, I had to put each station into separate workbook, so many solutions that works within one workbook will not work for me. I am not familiar with macro writing, but if that is the only reasonable solution I will go for that.
Thanks for any recommendation!
Gerti
I would ask about an issue probably faced many of you before. I
have a complex sheet of formulas that should be applied for different input data. The length of the input data is 4 columns and 13300 rows (30 years daily weather data). I have different input data gained from 10 different stations. The formulas will be developed and modified in time. Currently, I am looking for a solution to create a master sheet, in which I can put in data of different cases while at the same time I can modify the formulas themselves in the master sheet if it is necessary. Please consider that I need the results of these calculations continually summed up, maintained and updated in another workbook. With this I would like to save time of repeating the same formula alterations through several files (each one belonging to a weather station). Because of the file size, I had to put each station into separate workbook, so many solutions that works within one workbook will not work for me. I am not familiar with macro writing, but if that is the only reasonable solution I will go for that.
Thanks for any recommendation!
Gerti