I have considered the use of IF
statements via worksheet  cells, but I am trying to avoid using too
many Defined Named Ranges. In regards to determining the extent of
the data  ranges, I have already created code  that identifies the
start and end cells that correspond to the sf ranges in the single
column. I do by looping through the single column, removing
duplicate entries, sorting the resulting unique  list, and then
cutting the MTM and inserting it at the top of the list. From the
list of unique years, I can ascertain the position of the first sf
cell and last sf cell  in the list  by use of the OFFSET and COUNTIF
functions via code.

Assuming I can already identify the first and last cells in the
single column  that contain the sf corresponding for each expiration
year, how do I structure a For loop that copies the range  of SF
cells that correspond to each particular unique year  header, and
then procedes to the next year header?

I still have quite a bit to learn about VBA, as you noted!
Any assistance would be appreciated. I have posted another message
that illustrates the way the data is set  up if you would like to see
it.