User Tips |
Combining SpreadsheetsFirst let me say that this tip is not for the faint of heart. But for those of you who are experienced with MS Excel the following suggestion can be quite useful. This tip came from Carl Hommel I have a tip that you might wish to include in a future newsletter. Almost all my census information concerns people who lived in New York State, and I have been collecting census data from both the Feds and NY State. Using your templates, I would have two Excel speadsheets for each individual (one the Federal Form, and one the New York Form). What I did was to combine the two forms, so I have a master template that has all the worksheets from the Federal spreadsheet and the New York spreadsheet. When I enter data for an individual from Federal census records and New York Census records, they are in the same document. When I finish with an individual, I delete the worksheets for which there is no information (they were not born yet, or had died). Experienced users of MS Excel can quite easily customize my spreadsheets to suit their needs. Individual worksheets in a spreadsheet can be deleted to save hard drive or floppy space. Worksheet pages can also be cut and pasted between spreadsheets tostore data as described above. If you are not experienced in Excel I would recommend making a fresh copy of any spreadsheet(s) you plan to experiement with. As long as you aren't using your only copy of a spreadsheet you can't do any damage by trying new things. |
|
1. News from CensusTools |