Find Jobs
Hire Freelancers

Create macros to run a simple spreadsheet like a web page

$30-250 USD

Closed
Posted over 6 years ago

$30-250 USD

Paid on delivery
So, there are 3 columns: 1st column named PROCESS has 5 processes in it. 2nd column named TEAM has names of all the teams responsible for each process. 3rd column named RESPONSIBILITY has the detailed listing of the responsibility for each team for that process. This spreadsheet needs to work like a web page where When I click on button of a process, I should be taken to a next sheet where all the teams under that process should show up as buttons, and when I click on one team, its detailed responsibilities should show up as text in the final sheet. D7 to D17 is merged as "Plan and Prepare". When I click on "Plan and Prepare" I should go to the next sheet showing cells E7 to E17 as 11 buttons. When I click on button "Cell value of E7", the data in cell F7 should show up in the final sheet. I go back to Sheet containing E7 to E17 as buttons and now When I click on button "cell value of E8", Data in cell F8 should show up in the final sheet and so on... D18 to D22 is merged as "Detection and Reporting" and this show up as a button in the first sheet along with "Plan and Prepare" and the process follows like above for data in respective column E and F. I want different buttons for each unique entity in column d, and when I click on one button, it should take me to the next sheet where all fields under that entity are again shown as different buttons and when I click the button with E8, next sheet should show me trxt in F8
Project ID: 15344247

About the project

20 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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
20 freelancers are bidding on average $117 USD for this job
User Avatar
Hi, I' can automate your Excel. Relevant Skills and Experience Excel, vba Proposed Milestones $155 USD - default
$155 USD in 3 days
4.7 (10 reviews)
4.8
4.8
User Avatar
I would like to take this project Could you please share the excel sheet that you have with these information which will help me to understand the sheet and share working to give you a video demo Relevant Skills and Experience VBA Proposed Milestones $222 USD - final payment
$222 USD in 3 days
4.9 (16 reviews)
4.7
4.7
User Avatar
A proposal has not yet been provided
$100 USD in 2 days
5.0 (21 reviews)
4.7
4.7
User Avatar
I am a guru in Excel, and I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Therefore, I can help you design, build or modify spreadsheets in Excel to deliver professional analysis and reliable functionality suited to your needs. I offer you 35+ years of experience working on a variety of companies including, VC's, privet investors, entrepreneurs, startups, retailers, power plants, farms, insurance, universities, constructions, medical equipment manufacturer companies, traders among others.
$250 USD in 3 days
4.1 (5 reviews)
5.3
5.3
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$155 USD in 3 days
5.0 (5 reviews)
3.1
3.1
User Avatar
A proposal has not yet been provided
$90 USD in 7 days
5.0 (1 review)
0.9
0.9
User Avatar
Please PM me your data and I'll work and send you a sample. I've created a similar excel macro couple months ago. I am new to freelancer platform, but have severed many international cooperatives also small businesses. I am expert in creating/transforming big data into extremely user-friendly excel sheets, so that user can finish their daily and complexed work in simplify a click of button.
$100 USD in 1 day
5.0 (2 reviews)
0.4
0.4
User Avatar
Intrested to work in your Project. Relevant Skills and Experience Excel Macros, Excel VBA Proposed Milestones $75 USD - Initial Milestone $80 USD - Final Milestone will ask if any.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are Expert data entry. We got 5/5 Reviews,Please consider our proposal as we will finish your project faster than anyone and saving your time. Help us increase your popularity 100% Guarantee Relevant Skills and Experience Experts in Microsoft office ( Excel, Word, Powerpoint) Experts in Convert PDF to M.O. (any format ) Experts in Convert Scanned papers & Images to M.O. Experts in Data mining & formatting Proposed Milestones $155 USD - project
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
You need buttons, change pages, get and show values and texts with ways that connect some data and cells. I'm working with a worksheet for a tabletop game and worksheets for bioinformatic data science, that have a lot of things like this, like buttons to next sheets, get and show values of many cells, detecting changes in cells.I made all this things, desing all the worksheets and much more. Its my first time in freelancer.com, but I think that I can do your worksheet with VBA, geting values and changing values of final sheet, changing pages with codes, or creating a hidden calculation sheet, that will work along with the VBA codes, all this proccess, and just show that in final sheet. You can talk to me whenever necessary to make changes, about my methods or doubts during this process. I have a flexible schedule and usually respond quickly to messages and emails.
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivery of project well advance in time. Relevant Skills and Experience Excel, VBA Proposed Milestones $111 USD - Regular update on status of the project
$111 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
can you share the view you want and if you need to be on form or just on excel
$88 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Help you in this task with a low rate as looking forward to get rid of the 'new freelancer' status Relevant Skills and Experience Excel expert Proposed Milestones $155 USD - Help woth task
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Hyderabad, India
4.4
1
Payment method verified
Member since Oct 7, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.