Collating data from spreadsheet forms

$300-1500 USD

已完成

已发布

超过 16 年前

$300-1500 USD

货到付款

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.

Visual Basic

项目 ID: 191855

关于此项目

17提案

远程项目

活跃17 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@sensetech

Please see PM

$220 USD 在5天之内

5.0

(1条评论)

2.7

17威客以平均价$388 USD来参与此工作竞价

@xamdam91

Looking forward to working with you.

$300 USD 在2天之内

4.9

(54条评论)

6.1

@schandraram

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

$300 USD 在2天之内

4.9

(35条评论)

5.6

@KellogITSolution

Hi Plz check ur OMB for my bid. Regards

$300 USD 在2天之内

5.0

(15条评论)

4.4

@crajeshbe

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

$300 USD 在2天之内

5.0

(8条评论)

4.1

@guolibin

Hello,Please see the PM.

$300 USD 在7天之内

4.7

(6条评论)

3.4

@ExactSystems

Please see detail on PMB. Regards

$690 USD 在7天之内

4.2

(4条评论)

4.0

@cheungkc

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

$300 USD 在2天之内

5.0

(6条评论)

3.1

@ajay192

Please see PMB for a similar project delivered recently.

$799 USD 在7天之内

4.2

(3条评论)

3.6

@vnb400

kindly refer PMB, Thanks

$300 USD 在5天之内

5.0

(3条评论)

2.7

@kiracle

Hi! Please see PM for details. Thanks!

$300 USD 在3天之内

0.0

(0条评论)

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 have good command of english and I have impeccable writing skills. I am seeking for a challenging and informative project, and I believe this project serves it oven fresh. I assure you of quality output that wille exceed your expectations.

$600 USD 在30天之内

0.0

(0条评论)

0.0

@pbarbas

Can be done in 10 days.

$500 USD 在10天之内

0.0

(0条评论)

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 Engineering Study,,,etc. Doctor Dissertation Title: Research on the Oil Price Fluctuation and Risk Management (2) 1997-2000 Master Degree, School of Management, Dalian University of Technology, Major: Management Science and Engineering Study,,,, etc. Master Dissertation Title: Production Plan Support System (3) 1993-1997 Bachelor Degree, School of Chemistry, Dalian University of Technology, Major: Applied Chemistry Study,,,, etc. By years of study, I master the knowledge of chemistry and management. I also published over 10 articles on the publication, and took part in several research project. Because of excellent mathematics, I had won the first prize in mathematics competition. Working Experience 2005,1-Current: Toyo Heavy Industry(Dalian)Co.,Ltd. Company Introduction: We produce hydraulic system(including pumps, valves, cylinders, etc) according to customer’s requirement. Using the Numerical Controlled Lathe and Machining Center as basic manufacture tool, 96% of our products are sold to Japan, 3% of our products are sold to America, 1% of our products are sold in China. There are about 220 employees. Duty: 1 Production Scheduling I make the production plan by analyze the customer orderassembly capacity and producing plan, and assign the daily workshop producing. The production plan must assign every CNC every day duty. 2 Information Officer I develop production information system for my company. It has the MRP function, and has been used in routine operation. This system is B/S way, the database is SQL SERVER. 3 English Translator My English is better than other colleagues in my company. All the English Contact is charged by me. I had translated English Contracts, mechanical drawings, hydraulic technical information, etc. The production management system, which I developed, greatly improved the efficiency of making plan, order contact and searching production information. For example, in the past, it will take more than a day to checking the remaining order amount, now, one hour is enough. This system greatly improve our company information construction level.

$300 USD 在2天之内

0.0

(0条评论)

0.0

@KatoNamus

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

$300 USD 在0天之内

0.0

(0条评论)

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天之内