Combine several large excel spreadsheets with multiple pages of data that have common connecting data into one pivot table report or similar.

$30-250 AUD

已完成

已发布

大约 11 年前

$30-250 AUD

货到付款

I have several large excel spreadsheets that have data going back 10 years for a 64 site caravan park in Brisbane Australia. The data has each site's details with names and charges for each week for the last 10 years. There is another page in the same spreadsheet that has all the payments made. For the last year a new payment system was introduced that used an external finance collection service. Payment files for rent and electricity are received every couple of days and these are copied and pasted into another spreadsheet. There data that connects all this data is the site number. What I would like is pivot table style report that combines all this data and filters on site number and occupier name.

Data Mining

Excel

Report Writing

项目 ID: 4375107

关于此项目

7提案

远程项目

活跃11 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!

$150 AUD 在3天之内

4.9

(45条评论)

5.6

7威客以平均价$110 AUD来参与此工作竞价

@mrbrave

Excel expert with great experience here...Lets get started.

$105 AUD 在2天之内

5.0

(76条评论)

5.4

@deepbluetech

I can take on the job. Let me know

$125 AUD 在3天之内

5.0

(58条评论)

5.1

@binaryromel

##### Excel expert here! Please check PM. #####

$96 AUD 在2天之内

4.6

(43条评论)

5.0

@Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert ============================== Tablassus Software "Simple Solutions for Complex Problems"

$99 AUD 在1天之内

5.0

(11条评论)

4.2

@ChetanRajesh

As I understand you are looking at Integrating all the required data in one sheet - Basically in a Pivot Table view. I can get this job done in 3 days. My approach to this would be a one time solution. Starting with working on a standard format with application of some formulas, you should be able to derive the report you are looking for just by updating the data in future.

$120 AUD 在3天之内

0.0

(0条评论)

0.0

@petkoff86

I am new freelancer, but I have more than 3 years experience with processing data in Excel. I would like to work with you on this project. Have a nice day!

$75 AUD 在2天之内