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

Ταυτότητα εργασίας: 4375107

Σχετικά με την εργασία

7 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 11 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο 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 freelancers δίνουν μια μέση προσφορά $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 ημέρες