i need to generate the pattern in sheet 1 attached in Book3.xls. does any macro guru have a clue how i can go about generating this ? is there anyone who has worked on such a pattern before ? it wud be really kind if you could provide me some input into this one....