selecting row data meeting countif criteria

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

anyone? i'm desperate here


april2579 wrote:
> 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

How about adding a helper column (AB?) and put a formula like:

=aa2<today()-5

Then you could apply Data|filter|autofilter to that column.

Then filter to show the rows you want to copy and copy the visible cells to the
other sheet.

If you need code, you can record a macro when you do it manually.

april2579 wrote:
>
> 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

--

Dave Peterson