View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
david david is offline
external usenet poster
 
Posts: 24
Default Conitional copying of a serie of rows from one spreadsheet to another

I have a large worksheet with data in it. I want to copy only those
rows that meet certain criteria to another worksheet. For instance - If
there is a certain value in column C and a date in column D falls
between a certain range I want to copy the data in the row to another
summary worksheet. I want to ignore the rows where the conditions are
not me so I don't have gaps in the summary.

Help greatfully received


David