comparing dates and copying data

• • Reply

  13 years ago

  by Fnark

  Jim

  , United Kingdom

  Joined 13 years ago

  Hey guys (and gals), first up hello, im new!

  Im doing a peice of college work where i have an excel spreadsheet that you can enter names and other information in from a form. One particular thing i have on it is after you have set the members join/renewal date, it adds on a year and automatically puts this in a seperate column for an expiry date. The problem im having is taking all the rows in which the expiry date is less than the current date, copying them and then pasting them to another spreadsheet. Any help would be greatly apprecicated, Thanks!

  Report abuse