Thanks for your help and to respond....
Bgeier,
There is always a 0 or 1 in the fields.
P3/ p4 will determine whether some or all of these are wanted. The
macro looks a a template of 0 and 1s. Different templates will have
different bits that need to be either copied or ignored and go onto the
next sheet. Incidentally some bits in the bit pattern are used to derive
what the next sheet name will be in P5 (I will do this later on with a
Vlookup once the code works 100%) E.g. the forst 4 bits 1001 pattern
could mean make P5 = SHEET 3, 1011 could mean make P5= Sheet 2.

I hope this helps you understand what I am trying to do.
Thanks for your help.

JMB
Thank you too, I will try this in the morning, much appreciated.


MUDraker.


Wow you are outstanding, thanks for all the code. I tried it out, but
get error 1004 application defined or object defined error. I F8
stepped through it, it gets to
sH.Cells(i, j).Value = cell.Value then errors, so does not get to
loop.
Do you know what it might be? i ran the previous macro to check I hadnt
screwed up some values on the sheets somewhere and it seem to run as
before

Thanks again

Cheers

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=543596