I'm trying to make a macro to search a column for when values are
greater than zero (it will be a variable length range). Usually, this
column being searched is column T in the worksheet. Once that range is
found, it will need to select the five cells above the range (where
values are zero), and the five cells below the range (where values are
also zero). These three smaller ranges are added together to make a
single range. In the six adjacent columns before the one searched,
there is data that needs to be graphed corresponding to the searched
range. I'd like it to make a new worksheet for each of the six data,
copy the data from the main sheet into the individual pages, and then
graph the data.
Any help is appreciated! Thank you.