katiem_7626
New Member
- Joined
- Aug 19, 2013
- Messages
- 2
I have a spreadsheet with thousands of records relating to samples at water monitoring stations. Each sample is from a specific station of which there are over 1000. Each relates to a sample, so station IDs are repeated many times in rows. I need to run a macro that will use the forecast function to predict a sample value from each station. So everytime the station changes, a new forecast function will be ran on the sample values, producing a new prediction value for every station. I am struggling with building a macro - I know how to do the forecast function, but have far too much data to run it individually for each station. Any help would be greatly appreciated.<o
></o
>
Katie<o
></o
>


Katie<o

