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

Completed

Posted

about 11 years ago

$30-250 AUD

Paid on delivery

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

Project ID: 4375107

About the project

7 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 3 days

4.9

(45 reviews)

5.6

7 freelancers are bidding on average $110 AUD for this job

@mrbrave

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

$105 AUD in 2 days

5.0

(76 reviews)

5.4

@deepbluetech

I can take on the job. Let me know

$125 AUD in 3 days

5.0

(58 reviews)

5.1

@binaryromel

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

$96 AUD in 2 days

4.6

(43 reviews)

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 in 1 day

5.0

(11 reviews)

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 in 3 days

0.0

(0 reviews)

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 in 2 days