Add text to begining of cells within a range based on specified criteria

[jsd219]

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

 

[Dave Peterson]

You have a response at your other post.

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

 

[jsd219]

Are you refering to the question asked by Pete? or is there another
response that i did not see?

God bless
jsd219

 

[Dave Peterson]

Since you posted to multiple newsgroups, you'll have to check each of those
newsgroups for responses.

That's one of the problems with doing this--it makes more work for you.

The other problem is that if you already have an answer in a different
newsgroup, it wastes the time of anyone answering in this newsgroup.

 

[jsd219]

I posted in four newsgroups and have been monitoring all four. i do not
see a response other than Pete asking why i am not doing this in word.
is there another response that i have overlooked? please let me know i
am desperate.

God bless
jsd219

 

[Dave Peterson]

That's the one I saw, but since you multiposted, you'll have to continue to
monitor all responses.

I posted in four newsgroups and have been monitoring all four. i do not
see a response other than Pete asking why i am not doing this in word.
is there another response that i have overlooked? please let me know i
am desperate.

God bless
jsd219