I have a worksheet with rows covering 14 columns from (Axx
to Nxx).
The first row contains a date. The other rows contain
miscellaneous other data.

Out of all the rows already in the worksheet, I need to
select those rows (they are consecutive) that satisfy the
following criteria:

Select row if Axx = Today()-1 (Axx is already formatted as
a Date)

In other words, I'd like to select all rows with
yesterday's date and paste them to another worksheet.

I've already written a macro that does that, but I have to
select the rows myself before the macro copies and pastes.
That macro would look a lot better if it could work
unattended.

Thanks in advance for any help.