Condense Rows and create chart based on Cell Value

$30-250 AUD

Completed

Posted

almost 10 years ago

$30-250 AUD

Paid on delivery

We have a Sales Budget Spreadsheet where we show our Sales People and their projected budgets for the next 12 months. The Sheet is split into Budget / Adjustments / / Anomalies / Daily Averages We require macros created so a salesman can be picked and all non relating rows are hidden. We would also like a chart displayed plotting month on month from the projections. Also we would like it to do the same for Branches. All salespeople are assigned to a branch, so when a branch is chosen, only those salespeople will be shown and a chart is also displayed. It needs to be able to search for values as apposed to hard wired to rows as the Salesman may be added or removed and salesman may change branches and we dont want to have to re-write the code to accommodate this. I have attached and example of what the current budget sheet looks like. You need to be able to work over RDP. We have an RDP user with Excel, Access, Teamviewer and all other tools you will need to work with, you just need a stable internet connection to dial in on.

Excel

Visual Basic for Apps

Project ID: 6114833

About the project

10 proposals

Remote project

Active 10 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:

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience creating and enhancing spreadsheets, working with complex formulas and macros to process information. Check my excel reviews. From what you say, maybe do not need to work with macros. Chat with me. Greetings.

$155 AUD in 4 days

5.0

(327 reviews)

7.5

10 freelancers are bidding on average $137 AUD for this job

@deepbluetech

Hi, I am an Excel expert and can handle the project. Let me know and we can discuss further regarding the requirement. Please provide any existing output sample template you have in mind. Regards, Arul

$200 AUD in 3 days

5.0

(205 reviews)

7.4

@zExcel

Hi, I'll be happy to help you with this project. I can give the solution rather quickly once the requirement is fully clear. The solution will be in the Excel file itself. I don't do RDP Please feel free to message me if you need to discuss any questions

$150 AUD in 1 day

4.9

(254 reviews)

7.7

@pashute

I'm on Israeli time, and do not work on Fridays and Saturdays, but do on Sunday. I'll make you a small form that has a dropdown where you choose the branch or the salesman. Accordingly you'll see only that salesman's or branch's records. In addition you can create a chart in a new sheet, or if there's room on the open sheet. This you will decide when giving me the job. The form will be shown by a button that's on the sheet in the corner. Or (for some extra pay) in the ribbon. I'm assuming Excel 2010, but can work for 2003 and up. I can finish this in two or three hours.

$66 AUD in 1 day

4.9

(6 reviews)

3.9

@Subburaj01

Hi There, How are you doing? I can finish this project within a day and my price is negotiable. have 8+ years of experience in IT programming and good knowledge in VBA, Access/Excel , SQL web development tools. Moreover have done a lot of similar projects in the past and recently one for an UK employer - you can find the project "Parse XML file into access DB" in my profile - received very good review for this and even got some additional bonus :-) Please contact me to discuss further about the requirements in detail and get started. My goal is win-win for both of us to establish a long good standing relationship and gain good reputation. Wish you all success. Thank you +1 408 818 0033

$131 AUD in 2 days

5.0

(3 reviews)

3.2

@SHhadun

Hello, I'm experienced business analyst for the worlds 3rd largest wholesale company, so this kind of Excel task is my daily work. I need to just check with you few things: 1- do you use new version of Excel or not? 2- will you be using this macro on MacBook or just on Win computers? (writing code for Mac is little different) 3- Data for this Excel is manually entered or is it from some kind of data source? 4- Did you consider to change design of worksheet? I think that it can be a huge step forward, if we change it a bit. I need all this info in order to estimate scope of work needed. Hope to here from you, BR, Dusan

$140 AUD in 3 days

5.0

(6 reviews)

1.9

@mdallas4hire

I have been doing projects like this all day every day for the past 6 years. I know that I will not only exceed your expectations, but impress you enough to make me your "go to guy" for any future automation needs that may come up in your business!

$94 AUD in 1 day

2.4

(1 review)

0.8

@mikel18

pls send an e-mail add where i can send a sample on your project.. then you can decide on my work whether to accept or not. thank you..

$166 AUD in 3 days

0.0

(0 reviews)

0.0

@MarathTamizhan

Hi, I have 12+ years in programming and can do this Job. Working RD.. not a problem. Since you have already mentioned that this is a macro, I presume we gonna work only on VBA and Excel. By the way I have few questions. 1) Can you explain a little more on your statement. "We would also like a chart displayed plotting month on month from the projections." 2) What is could not see in the spread sheet is the relation between the branches and salesmen. These two tables seems to be mutually exclusive. Will be happy a demo by you on the outcome you want to see by manually showing it to me ONCE through RDP. So that we are sure on our requirements. -Take care

$111 AUD in 1 day