Gav,

What I was thinking was that I could start at one point and just get
everything to the right. What you say seems to preclude that.

Alternative, is it text of 'Options' and 'Inclusions' so I can search for
that text specifically and get the associated columns? And how many rows do
I go down ,what is the rule? And fin ally, the target heading of 'Appendix,
again is this the text value, and should it just be copied below that and to
the right?

Oh, an I am off to bed, so it will be at least 12 hours before I pop back
in.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gav meredith" wrote in message
...
hi bob, to give you an idea, options and inclusions are in between other
content of a document. Currently, Options is located on A10 and inclusions
is located on A14. Text will appear after these headings after a user
inserts it and once the user has inserted the text, i would like excel to
recognise this and copy the appropriate heading and content. Other text does
appear after these headings also.

Any ideas??

Thanks so much!!!!