Automate excel spreadsheet by creating formulas

Hi there

I have a 'net profit calculator' that i am needing assistance to automate.

The user defines their target net profit, then their overall expenses, their cost per unit and then sell price.

The intention of the calculator is then to returns results on the number of sales required, expenses, gross sales to reach the target net profit.

Then if the user add multiple units, it assumes equal value across each unit.

Ideally the result would show the units for each product - then the user could edit the units up and down to show its effect on net profit.

I have uploaded the sample basic version which has been done using manual calculations.

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: how to automatically update one excel worksheet from another sheet, excel automation tools, excel automation, excel automation examples, excel formulas, automated spreadsheets, how to automate excel reports using macros, how to automate data entry in excel, excel spreadsheet quickbooks, send bulk mail excel spreadsheet, reformat excel spreadsheet, year plan excel spreadsheet, excel spreadsheet surgery cost, convert excel spreadsheet label, locking formulas excel spreadsheet, creating excel spreadsheet firefox, creating excel spreadsheet, creating gui interface excel spreadsheet, creating scripts excel spreadsheet, excel spreadsheet formulas

About the Employer:
( 6 reviews ) Dandenong North, Australia

Project ID: #27950237

Awarded to:


I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data A More

$40 AUD in 1 day
(95 Reviews)

12 freelancers are bidding on average $106 for this job


Hi, Greetings! ✅checked your project details: Automate excel spreadsheet by creating formulas ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same ki More

$220 AUD in 4 days
(392 Reviews)
(385 Reviews)

Hello there, I am ready to start your project right now. Lets have a discussion for further movement . Best- Nu Likhon

$150 AUD in 2 days
(54 Reviews)

Hi there, I can create net profit calculator in vba based on your requirements . I’m an Excel VBA expert and have 9+ years of experince in creating complex automation tools, formulas, databases, queries and macros. More

$75 AUD in 1 day
(59 Reviews)

Hi, Greetings! ✅checked your project details EAutomate excel spreadsheet by creating formulas ✅Completed Time : 24 hours(independent and fast workers only) or your requirement deadline . I would like to work on your p More

$40 AUD in 1 day
(16 Reviews)

Hello I have check your Feasability Calculator Multi Product [login to view URL] carefully . I am a expert in automation calculator . I have read your details carefully. So i can give you good result with this project. Please More

$250 AUD in 5 days
(1 Review)

Hi, I have checked the project : Automate excel spreadsheet by creating formulas I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extra More

$140 AUD in 1 day
(11 Reviews)

Hello Hope you are having a great day. I have read your requirement and I understand that you need an expert in MS Excel and VBA. Your goal to calculate maximum net profit can also be done through Solver Plugin. I hav More

$100 AUD in 1 day
(6 Reviews)

Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA. I will finish your Excel VBA project in time with high quality Hope your More

$50 AUD in 1 day
(2 Reviews)

Hello, I will do your these calculations. I am Data Entry Operator by profession with 8 Years Experience. As I have crush on typing and calculating I will do your job perfectly, also facilitate further more about my gi More

$30 AUD in 4 days
(0 Reviews)

I am a hard-working, methodical and driven individual with more than three years of experience in the Data Entry field and with the ability to input and manage data accurately, with great speed and in high volumes. I a More

$35 AUD in 7 days
(0 Reviews)