Findnext

[Guest]

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

 

[David McRitchie]

Hi Noemi,
I guess your question was not clear about what you actually need
and what use of vlookup has to do with the question, and perhaps
why you wouldn't just manually delete columns...

Perhaps you would want to copy the entire sheet to another but with
values instead of formulas and then you can delete columns without
regard to formula usage in the copy -- leaving the original intact.