Hi
I am not very familiar with loops and FInd Next so I am hopping to get some
help.

We have an excel spreadsheet which we are coping the data from and into
another spreadsheet so we can do vlookup's however the excel spreadsheet
currently has numbers up the top as a heading rather than down the column
while our other spreadsheet which would compare against is down the column.

When copying the details over we would like to find a word that is repeated
numerous times as headings and delete the information bewteen the two
headings once copied to comparison spreadsheet.

I hope this makes sense and someone can help.

Thanks
Noemi