Thanks for the tip! Took me several hours the copy and paste each page of the list of everyone in the tree, but now have my spreadsheet set up. i use columns for each census year. Then when I find a record, enter the state initials in the cell. The spreadsheet lets me sort or filter records to look for blanks. It is really helping organize my research. I just couldn't find a software out there that would do this type of report.