I have a workbook containing many sheets. The first sheets are years ("2005",
"2006", "2007", "2008") followed by sheets for each individual project
("00387"..."00798"). The year sheets look up information from the project
sheets and this has not been a problem.

What I would like to do is have each year sheet look at the rows in the
previous year and if the final colum "S" is not equal to "Closed" then copy
the row into themselves.

I know the Lookup functions need to look at the firrst column. Any hellp
would be gratefully received!