The purpose of the application is to collate data from a number of spreadsheet forms (see attached file RCA Record) into a table in a summary spreadsheet (see attached file RCA Summary). It is envisaged that once a month the user will be able to open the summary spreadsheet and press a button to import data from all spreadsheet forms. The summary spreadsheet will be recreated from scratch each month and a copy retained to keep a history. All spreadsheet forms are of identical fixed structure and there may be up to 200 within the folder. The import data is clearly shown at $B$61:$N$61. It is envisaged that this application will have a very short life (< 12 months) during which it will get incorporated into a corporate system. It is likely that minor changes will be needed (e.g. add an extra data item) and the client is capable of making minor changes to the source code to cope with these small variations as long as the source is clearly documented. Error handling is important and a simple report of files within the folder that caused errors (e.g. did not have the named worksheet) would be useful.
19 freelancers are bidding on average $416 for this job
I provide superior quality code, thorough documentation, and guaranteed satisfaction. I have extensive experience in Excel and VBA. Please see my profile for more information.
we are a 4 member team . all having 3+ yrs experience in s/w development.may b we can complete it before 2 days and in a smaller budget . pls provide the complete details