Microsoft Excel - want to find cells with particular info, but info is in multi-lines. Can one helpme

Hi nullskullers,
(my eggheadcafe friends).

I am working on a excel file where heading are inputed in cells are multi-lines.

I want to create a macro which would copy the data from a range below the required head and paste in other template.
The head row coloum shall not be fixed. So I first need to search the heading and then select the coloumn data.

would anyone help me to find those multi lines in single cell heading I required.

E.g.
"multi lines in single cell"  <== this nornally we find in single line single cell

"multi lines
in single cell"             <== this multi line in single cell


Required in urgent
Thanks in advance
Regards

Hello Sandeep,
Have a look at this file and the macro that it contains.  Hopefully it will get you on your way.
sandeep.zip
Regards
Harry

Thanks Harry,

I'll check and let you know.

Regards