D
Doehead
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
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