Can Excel do this.

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

Sheet 3 has rows that end in a date.

If that date is greater than: e.g. 1st August.2003 then I want those
rows to be posted to sheet 4

In other words it is a way of solating on another sheet some updates,
so they can be saved to a website or printed without fuss.

I
 
Thank you. I'll try.

Select the range, and select AutoFilter from the Data menu. Click on
the drop down arrow on the Date column, select Custom. Select greater
than or equal to from the top left dropdown on the dialog, and type 1
Aug 2003 in the top right box, and press okay. Now select the filtered
range, copy, and paste into the second sheet.

- Jon
 
Back
Top