Hi Otto, thanks for replying, I would want to paste them in sequential
columns on the new spreadsheet.

"Otto Moehrbach" wrote:

Let me explain what I mean. Let's say you want to copy 15 columns, or 30
columns, or 50, it doesn't matter. They are not sequential columns, maybe
some are, and they are scattered all over the place, just like your source
columns are. Copying those columns is easy in VBA. OK, we're done with
copying. Now let's talk about pasting all this data we just copied. This
is the question I have. A pasting question. Do you want to paste these
umpteen columns of data into sequential columns? That is easy in VBA. Or
do you want them pasted into non-sequential columns? If so, what columns?
HTH Otto
"Doehead" wrote in message
...

Hi Otto,

I want the destination columns to only include specific source columns.

Source columns: A through to AU
Destination columns: would start at A but would copy over B through W plus
AG,AJ,AL,AN,AP,AR and AT from the source spreadsheet.

I have created the destination header row to match the specific source
header titles that I need in the destination spreadsheet.

Does this make sense? Thanks, Doehead

"Otto Moehrbach" wrote:

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