for eg:-there are somany headers in the file in which i want to find one header value (if
the finding header is not avialable then find the next header value)
find the below format for the data
CSE_Name CB DNC EN Lead NFU NI OTHERS PGNI RING
carunpandian 0 0 8 0 0 35 2 0 15
ckoushick 1 1 4 0 2 12 7 1 11
golda 2 0 2 1 0 2 1 0 9
karthigaiselvi 12 3 35 3 2 43 68 1 153
kathirvel 4 0 56 0 0 19 70 0 41
kiruthikarani 4 1 35 0 6 31 72 0 56
in the above mentioned data i want to copy "CB" Value to the next sheet if the "CB"
value is not avialable then copy the next header (already defined).
Bookmarks