2 dynamic excel worksheets created

Completed Posted Jan 21, 2014 Paid on delivery
Completed Paid on delivery

Sales performance report - multi site.

We have a current SPR in an excel spreadsheet that we manually update weekly however I am looking for this report to be more dynamic so that we can enter sales in one sheet and then have that info sucked into other sheets by things like rep name etc. I would like the SPA to have a "dashboard page" to be able to see a visual representation of results.

Warehouse management report - multi site

We have a current WMR in a excel spreadsheet which records stock movements in and out. I am just looking for this to be tied up and imporved, some formulas fixed etc

Excel

Project ID: #5346038

About the project

26 proposals Remote project Active Jan 24, 2014

Awarded to:

priyal1997

Dear Sir/Madam I'm happy to help you on this task I have both expertise need for this task (Strong excel skills and Strong financial background) You can visit my profile to see my reliability and experience in this More

$250 AUD in 4 days
(192 Reviews)
6.7

26 freelancers are bidding on average $309 for this job

ParisPallas

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check https://www.freelancer.gr/projects/Data-Processing-Excel/data-translation-e More

$250 AUD in 10 days
(554 Reviews)
8.6
zExcel

Hi, My name is Jon and I will be happy to help you with the project. Please feel free to message me prior to accepting my bid

$277 AUD in 2 days
(251 Reviews)
7.7
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 AUD in 4 days
(330 Reviews)
7.7
deepbluetech

Hi, I am an Excel expert and have been involved in a number of Excel based projects on Freelancer. Please confirm and provide further details. Shall make the Excel worksheet as user friendly as possible. Regards, Ar More

$250 AUD in 3 days
(173 Reviews)
7.4
maverick44000

Hi Mate. I am doing a very project in Excel that involves making a complex dashboard to manage inventory items. I shall be at east to manage the project for you as well. Lets discuss and get started on it. Regards. U More

$390 AUD in 4 days
(73 Reviews)
6.9
finecodervw

Hi, Would appreciate if you can please share the existing Excel sheets containing the SPR reports. Let me introduce myself as an expert in Excel and VBA programmer. I have used VBA extensively for Excel, MS Word More

$370 AUD in 10 days
(125 Reviews)
6.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$333 AUD in 10 days
(117 Reviews)
6.3
expertatwork

hey SeniorsPlus, looks like you have posted the project in a wrong category (250$+). Can you please share the excel sheets that you are using now ? thanks !

$250 AUD in 4 days
(155 Reviews)
5.9
MDavidCrompton

Hi, I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. More

$250 AUD in 5 days
(32 Reviews)
5.0
samin59

Meet the perfect match for your project. Please contact for quality and result oriented services. Regards

$263 AUD in 10 days
(10 Reviews)
4.2
dank111

Hi, I have worked on creating dynamic dashboards in excel and am an expert in automating reports so that there is minimal human intervention in generating those reports. That way you can utilize your time in other more More

$250 AUD in 3 days
(10 Reviews)
4.3
Midlander

I have already delivered several similar assignments, happy to work under a Confidentiality and Non-Disclosure Agreement if required, and will start as soon as you pay the Milestone into the site and send me your exist More

$250 AUD in 5 days
(11 Reviews)
4.5
designvin

Hello, This could be done using without much use of excel features. You need to use LOOKUP functions and link between sheets/files. Please let me know if I can help. Regards Vinod

$333 AUD in 10 days
(1 Review)
2.7
danaldea

Hi there, I'd be happy to help you with your project. My solution would be to have an input area where you can enter the data, which would be then replicated to a data warehouse where all your data will be stored, More

$250 AUD in 4 days
(5 Reviews)
2.1
akshayw

A proposal has not yet been provided

$250 AUD in 10 days
(2 Reviews)
1.6
GFsoul

hello i can do this project very well i have worked 3 years for excel and i know custom functions and macros as well i can design an excel sheet for you to have very easy to use and clear picture of your websites

$277 AUD in 5 days
(1 Review)
1.2
dineshajar

A proposal has not yet been provided

$500 AUD in 10 days
(2 Reviews)
1.4
davneet4u

Work to be started immediately. Take trial before giving work. Want to improve profile more than anything else.

$250 AUD in 2 days
(0 Reviews)
0.0
ghsh

Hello Sir, I am a report and service improvement specialist by profession with 4 yrs work experience, i think this job should be a great one to start my journey in Freelancer as i have just recently enrolled, my prio More

$250 AUD in 10 days
(0 Reviews)
0.0
cuberesources

Without seeing the original spreadsheets, it's a little hard for me to time the work but I would expect it would take a ~day to make draft changes... then depending on your feedback 1-2 days to finalise. I've also o More

$266 AUD in 3 days
(0 Reviews)
0.0