View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Naveen[_2_] Christopher Naveen[_2_] is offline
external usenet poster
 
Posts: 58
Default checking the headings

Hi,

I have a cols from A - FZ. I use to extract some report from the website and
daily i need to check the col headings whether it is matching or not. If the
extracted report does not matches my report heading then my formulas will not
work properly. I request you to help me on some function to check the col
headings

My report headings
A B C ---- FZ
Sl. No. Name Address Date

Extracted report headings
A B C ---- FZ
Sl. No. Name Address Date

If both the headings are not matching then it shud alert me. For exapmle in
the extracted report heading, Col C was changed to "XYZ" but my report
heading says "Address" so here the formual shud alert me saying that the cold
heading is not matching.

Can any one help me on this.

Thanks in advance!!

-Chris