okay.. I have a workbook that can have the data updated daily... it
performs a count and percentage of how many of the days orders are
older than 5 days... i cannot bridge a gap I have between the countif
data and the macro to eliminate unnecessary data of which we provide to
our client.

my data sheet contains 35 columns which is constant, the rows are
variable depending on the number of orders.

my countif critera counts the orders older than 5 days
=COUNTIF(Data!AA:AA,"<="&TODAY()-5)

What I need is a macro that will copy the entire rows in my data
worksheet where column AA meets the countif critera and paste them to
the client spreadsheet, I already have the macro written to eliminate
the unnecessary data...

Can anyone help? Please?

Thanks