Simple excel macro to update table of values, then graph them
- or -
Post a project like this1637
£50(approx. $62)
- Posted:
- Proposals: 20
- Remote
- #2577992
- Completed
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Data Entry,data scrapping,data mining.video editing,audio editing,ms word,exel,power point.
Dhaka
13004492744138325837632554313244104324206932305293213974321204131257443118614649865
Description
Experience Level: Entry
Hi All
I am looking for support with the attached excel sheet. There's a few things I want to do that are pretty straightforward. The purpose of this is to create a template that I can share on my investing website so it needs to be in my own branding.
I need the following help:
1. Create a simple macro that takes the "Net Worth" in cell I5 and reads the date in D3. Using that information it updates the "Net Worth" in Column B on the next tab (input tab). In other words it uses the month of the date in tab one, copies the net worth in cell I5, and pastes it into the net worth in B101 (because this month is October). Every time you press the button it does this. So when we get to November it does the same thing but pastes into B102.
2. Reformat the main input tab so that it fits within one page. I want a different design that uses the banner from my website (which I will send to you). Move the graph on 'input' into the first tab beside the table of information.
3. For the graph on the input tab, I want everything under the graph to show as Blue, up to today's month. In this case it should be blue up to October. For future months after October I want the graph underneath to be Orange in order to show that these are future values. The graph should know what date it is and change based on the inputs.
4. Lock the sheet to editing apart from the inputs and using the Macro.
In summary as a user I should be able to open the Excel, type in the data for this month, then click the Macro button. The excel sheet will automatically read the date, copy and paste the "Net Worth" figures into the table, and update the graph to reflect the new information. That's all it needs to be able to do.
Please bid for this job and I will look forward to working with you!
I am looking for support with the attached excel sheet. There's a few things I want to do that are pretty straightforward. The purpose of this is to create a template that I can share on my investing website so it needs to be in my own branding.
I need the following help:
1. Create a simple macro that takes the "Net Worth" in cell I5 and reads the date in D3. Using that information it updates the "Net Worth" in Column B on the next tab (input tab). In other words it uses the month of the date in tab one, copies the net worth in cell I5, and pastes it into the net worth in B101 (because this month is October). Every time you press the button it does this. So when we get to November it does the same thing but pastes into B102.
2. Reformat the main input tab so that it fits within one page. I want a different design that uses the banner from my website (which I will send to you). Move the graph on 'input' into the first tab beside the table of information.
3. For the graph on the input tab, I want everything under the graph to show as Blue, up to today's month. In this case it should be blue up to October. For future months after October I want the graph underneath to be Orange in order to show that these are future values. The graph should know what date it is and change based on the inputs.
4. Lock the sheet to editing apart from the inputs and using the Macro.
In summary as a user I should be able to open the Excel, type in the data for this month, then click the Macro button. The excel sheet will automatically read the date, copy and paste the "Net Worth" figures into the table, and update the graph to reflect the new information. That's all it needs to be able to do.
Please bid for this job and I will look forward to working with you!
David H.
100% (7)Projects Completed
7
Freelancers worked with
6
Projects awarded
60%
Last project
13 Feb 2023
Malta
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi David,
As per my understanding you want to update the 'Net Worth' column in the 'Data' tab as per the date in the 'Net worth Input' tab. So any value in the 'Net worth' field for a particular date would reflect in the data tab for the same date.
Also you want a redesigning of the graph.
Let me know if my understanding is correct
857266
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies