Käynnissä

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.

Taidot: Visual Basic

Näytä lisää: collating data, table data structure, simple data structure, data structure with c, data structure that, data structure code, data structure and c, basic of data structure, application of data structure in c, application of data structure, 12 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

Tietoa työnantajasta:
( 2 arvostelua ) bedford, United Kingdom

Projektin tunnus: #191855

Myönnetty käyttäjälle:

sensetech

Please see PM

220 $ USD 5 päivässä
(1 arvostelu)
2.7

19 freelancers are bidding on average $416 for this job

xamdam91

Looking forward to working with you.

300 $ USD 2 päivässä
(54 arvostelua)
6.1
schandraram

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

300 $ USD 2 päivässä
(55 arvostelua)
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 Lisää

995.95 $ USD 5 päivässä
(16 arvostelua)
5.0
KellogITSolution

Hi Plz check ur OMB for my bid. Regards

300 $ USD 2 päivässä
(12 arvostelua)
4.3
crajeshbe

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

300 $ USD 2 päivässä
(8 arvostelua)
4.1
ExactSystems

Please see detail on PMB. Regards

690 $ USD 7 päivässä
(4 arvostelua)
4.1
ajay192

Please see PMB for a similar project delivered recently.

799 $ USD 7 päivässä
(3 arvostelua)
3.6
guolibin

Hello,Please see the PM.

300 $ USD 7 päivässä
(6 arvostelua)
3.4
cheungkc

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

300 $ USD 2 päivässä
(6 arvostelua)
3.0
vnb400

kindly refer PMB, Thanks

300 $ USD 5 päivässä
(3 arvostelua)
2.7
usinkaya

I am expert in writing macro.

300 $ USD 3 päivässä
(1 arvostelu)
1.7
pbarbas

Can be done in 10 days.

500 $ USD 10 päivässä
(0 arvostelua)
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 Lisää

300 $ USD 2 päivässä
(0 arvostelua)
0.0
KatoNamus

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

300 $ USD 0 päivässä
(0 arvostelua)
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 Lisää

600 $ USD 30 päivässä
(0 arvostelua)
0.0
kiracle

Hi! Please see PM for details. Thanks!

300 $ USD 3 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
greeshmarajesh

we are a 4 member team . all having 3+ yrs experience in s/w [url removed, login to view] b we can complete it before 2 days and in a smaller budget . pls provide the complete details

300 $ USD 2 päivässä
(0 arvostelua)
0.0