進行中

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

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.

スキル: データマイニング, エクセル, レポートライティング

さらに表示: report writing system, excel spreadsheet rent, brisbane finance, australia brisbane, writing on multiple, spreadsheets, report writing service, pivot table excel, finance in excel, finance excel, finance excel data, excel service, Excel report, excel PIVOT, excel pivot table, excel finance, common, combine excel, spreadsheets data collection, data collection excel spreadsheet, finance data excel, data collection spreadsheet, data collection writing, excel collection spreadsheet, Brisbane Australia

採用者について:
( 2件のレビュー ) Beenleigh, Australia

プロジェクトID: #4375107

アワード:

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 co もっと

$150 AUD 3日以内
(45レビュー)
5.6

この仕事に、7人のフリーランサーが、平均$110で入札しています。

mrbrave

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

$105 AUD 2日以内
(76件のレビュー)
5.4
deepbluetech

I can take on the job. Let me know

$125 AUD 3日以内
(58件のレビュー)
5.1
binaryromel

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

$96 AUD 2日以内
(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 =============== もっと

$99 AUD 1日以内
(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 もっと

$120 AUD 3日以内
(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日以内
(0件のレビュー)
0.0