Hi,
I have a bunch of excel files full of data, and each one contains
information which needs to be made into 30 charts (scatterplots). I have
been hand selecting the data and then creating each chart manually, but I am
hoping there is a way to automatize the process. Basically what I need to do
is this:

3 adjacent columns of data
look down column 1 for the word "stop" (the rest are all numbers)
when you get to stop, select all three columns until the next time there's a
"stop" in column 1
make the scatterplot
do it again from the next stop (the stop lines can just be skipped when
selecting data for the chart)

Does anyone have any pointers for me?

Thanks so much!
Christina