In Progress

Collating data from spreadsheet forms

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.

Skills: Visual Basic

See more: collating data, table data structure, simple data structure, data structure code, basic data structure, application data structure, month spreadsheet, collating data business, collating information excel spreadsheets, collating data spreadsheets, collating spreadsheets corporate worksheet, report collating data, may g, summary table, rca to, open data, data visual, data handling, small data table, named, application named, import files folder, system data file, open table, spreadsheet forms

About the Employer:
( 2 reviews ) bedford, United Kingdom

Project ID: #191855

Awarded to:

sensetech

Please see PM

$220 USD in 5 days
(1 Review)
2.7

19 freelancers are bidding on average $416 for this job

xamdam91

Looking forward to working with you.

$300 USD in 2 days
(54 Reviews)
6.1
schandraram

Hello Please see PMB for details of my bid. Thank you

$300 USD in 2 days
(55 Reviews)
5.9
wsh2

This application really belongs in MsAccess, rather than MsExcel. MsAccess will allow for easy Excel import and export, and adds superior record selection, summarization and editing capabilities. Hello my name is Bi More

$995.95 USD in 5 days
(16 Reviews)
5.0
KellogITSolution

Hi Plz check ur OMB for my bid. Regards

$300 USD in 2 days
(12 Reviews)
4.3
crajeshbe

Dear sir, This is Rajesh. please see the pm details.

$300 USD in 2 days
(8 Reviews)
4.1
ExactSystems

Please see detail on PMB. Regards

$690 USD in 7 days
(4 Reviews)
4.1
ajay192

Please see PMB for a similar project delivered recently.

$799 USD in 7 days
(3 Reviews)
3.6
guolibin

Hello,Please see the PM.

$300 USD in 7 days
(6 Reviews)
3.4
cheungkc

We have reviewed the two files provided and are confident in providing the desired solution accordingly.

$300 USD in 2 days
(6 Reviews)
3.0
vnb400

kindly refer PMB, Thanks

$300 USD in 5 days
(3 Reviews)
2.7
usinkaya

I am expert in writing macro.

$300 USD in 3 days
(1 Review)
1.7
pbarbas

Can be done in 10 days.

$500 USD in 10 days
(0 Reviews)
0.0
fengchunshan

I am very good at Excel and VBA in Excel. I am very confident about this project. Education: Management PhD. (1) 2000-2004 PhD. School of Management, Shanghai Jiaotong University, Major: Management Science and En More

$300 USD in 2 days
(0 Reviews)
0.0
KatoNamus

Hi, I have a completed product ready for you. Please see PM for details.

$300 USD in 0 days
(0 Reviews)
0.0
rjmarie123

I am a service-oriented offshore individual with extensive experience, in data entry, blogging, captcha, virtual assistance and many other. Although I am not an American, I am abreast with the current situations. I ha More

$600 USD in 30 days
(0 Reviews)
0.0
kiracle

Hi! Please see PM for details. Thanks!

$300 USD in 3 days
(0 Reviews)
0.0
Philleas

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.

$495 USD in 7 days
(0 Reviews)
0.0
greeshmarajesh

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

$300 USD in 2 days
(0 Reviews)
0.0