This is a tuff one (at least for me). I need to select the contents of
a cell based on the contents of another cell and then I need to add
that text to the begining of other cells until I reach the destination
cell.

below is an example of what i am trying to do:

STANDARDS FOR FOREIGN LANGUAGE LEARNING
Vocabulario en acción 1
Communication 1.1 Students engage in conversations, provide and obtain
information, express feelings and emotions, and exchange opinions
Communication 1.2 Students understand and interpret written and spoken
language on a variety of topics
Communication 1.3 Students present information, concepts, and ideas to
an audience of listeners or readers on a variety of topics
Cultures 2.1 Students demonstrate an understanding of the relationship
between the practices and perspectives of the culture studied
Comparisons 4.2 Students demonstrate understanding of the concept of
culture through comparisons of the cultures studied and their own
CORE INSTRUCTION

I need to find cells with "STANDARDS FOR FOREIGN LANGUAGE LEARNING" i
then need to extract the contents of the cell below it "Vocabulario en
acción 1" i need to delete this row and then paste this at the
begining of all the cells below until i reach "CORE INSTRUCTION"
below is the end result:


STANDARDS FOR FOREIGN LANGUAGE LEARNING
Vocabulario en acción 1 - Communication 1.1 Students engage in
conversations, provide and obtain information, express feelings and
emotions, and exchange opinions
Vocabulario en acción 1 - Communication 1.2 Students understand and
interpret written and spoken language on a variety of topics
Vocabulario en acción 1 - Communication 1.3 Students present
information, concepts, and ideas to an audience of listeners or readers
on a variety of topics
Vocabulario en acción 1 - Cultures 2.1 Students demonstrate an
understanding of the relationship between the practices and
perspectives of the culture studied
Vocabulario en acción 1 - Comparisons 4.2 Students demonstrate
understanding of the concept of culture through comparisons of the
cultures studied and their own
CORE INSTRUCTION

I have 7000-8000 rows if info similar to this but it varies in the
middle. i would love to be able to have a box ask me for the text to
look for i.e. "STANDARDS FOR FOREIGN LANGUAGE LEARNING" and then a box
asking me for the text to end "CORE INSTRUCTION"

If anyone can help with this i would really appreciate it

God bless
jsd219