Do you want the destination columns to be the same columns as the Source
columns or do you want to copy the Source columns then paste them in
sequential columns? Starting with what Destination column? HTH Otto
"Doehead" wrote in message
...
Hi all,

I am trying to copy a complete row of data to another sheet when it meets
the criteria:

Source data is in sheet: Master, cols A to AU,
data from row 2 down, with key col X & criteria value: Closed

On new sheet: Closed
Placed in A2:
=IF(Master!X2="","",IF(OR(Master!F2="Closed"),ROW( ),""))
Left A1 blank

In B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(x!A:A,SMALL($ A:$A,ROWS($1:1))))

This formula has worked for me in the past for another workbook when I
have
had to copy over a complete row to another sheet.

Bigger problem..I have been asked to copy only certain columns to a
different sheet in the same workbook.

Again source data is in sheet: Master, cols A to AU
Data from row 2 down, with key col Y & criteria value: Yes

On sheet: Women's Health
Need to copy only columns B through W plus AG,AJ,AL,AN,AP,AR and AT when
the
column Y criteria is Yes.

There is actually 5 other sheets they want me to create using different
criteria, can Excel do this?

I do not how to do macros or VB, please help. Thanks