If interested, the format on sheet 1 needs to be transformed to the
format shown on sheet two.

Where the Q1, Q2 etc. are listed on sheet 2 only if they have an H, N
or R value on sheet 1.

About 1000 rows and the Qn's extend as far as 103 per row. Rows
apparently are not all the same number of columns, some 30 column,
some 103 and many in between.

Well.., the logic on Sheet2 escapes me because Name4 has an "H" in Q3
but is not formatted.

The other names have the criteria in more than 1 Q, but no formatting
other than the last Q containing criteria.

In order to code this the criteria needs 'structured' logic!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion