Assist in developing excel database for HR Data verification and audit. Would like following features: - Split database into multiple worksheets - roll up multiple worksheet into one database (including doing a check for errors) - track changes upon last save in worksheets - create dependent pick list and dialogue boxes for worksheets - protect portions of worksheet ------------------------------------------ Added 4 APR 2012, 11:10 AM EDT Essentially create sub files from 1 master file. Each sub file can have up to 2,500 records. Process is as follows: 1. Create sub files from master file based on criteria provided (can select entire organization or a portion) 2. Sub file sent for 2 levels of data entry/review (some columns are protected), in review/ data entry, entry is done through pick lists, dependent pick lists, manual data entry. Once first level is complete ability to lock columns and allow 2nd review to take place. Once done lock columns. 3. Rollup files into master file. Total number of records in master file approx 10,000 rows of data. ------------------------------------------ Added 4 APR 2012, 11:10 AM EDT Essentially create sub files from 1 master file. Each sub file can have up to 2,500 records. Process is as follows: 1. Create sub files from master file based on criteria provided (can select entire organization or a portion) 2. Sub file sent for 2 levels of data entry/review (some columns are protected), in review/ data entry, entry is done through pick lists, dependent pick lists, manual data entry. Once first level is complete ability to lock columns and allow 2nd review to take place. Once done lock columns. 3. Rollup files into master file. Total number of records in master file approx 10,000 rows of data. Desired Skills: Microsoft Excel Keywords: Other - Administrative Support, Microsoft, Excel