Excel table
- or -
Post a project like this1510
£15(approx. $19)
- Posted:
- Proposals: 5
- Remote
- #2729873
- PRE-FUNDED
- Awarded
Description
Experience Level: Entry
I have a model where I need to show the potential roll-out of multiple branches of a concept.
Originally this was at fixed intervals but now I need to be able to vary it.
On the attached tab "Consol" I have fields in yellow where I want to be able to put a 1 in any month which with then trigger the set-up, sales and costs on tab "Larger P&L" to be brought into the Consol tab at that point.
I have attached the spreadsheet.
For example, if I put a 1 in cell X9 on the Consol tab, I want it to bring through cell F8 on the larger tab into cell X31 on the consol. (so that is the sales figure. Then I want cell X2 on the Consol tab to bring through cell G8 on the Larger tab and so on across the row.
You can just do one row - I should be able to work it out from there - if I can't I will come back to you!
Please only apply if you know exactly how to do this I as don't want to waste time, it should be pretty straightforward if you know how!
Thanks,
Mark
Originally this was at fixed intervals but now I need to be able to vary it.
On the attached tab "Consol" I have fields in yellow where I want to be able to put a 1 in any month which with then trigger the set-up, sales and costs on tab "Larger P&L" to be brought into the Consol tab at that point.
I have attached the spreadsheet.
For example, if I put a 1 in cell X9 on the Consol tab, I want it to bring through cell F8 on the larger tab into cell X31 on the consol. (so that is the sales figure. Then I want cell X2 on the Consol tab to bring through cell G8 on the Larger tab and so on across the row.
You can just do one row - I should be able to work it out from there - if I can't I will come back to you!
Please only apply if you know exactly how to do this I as don't want to waste time, it should be pretty straightforward if you know how!
Thanks,
Mark
Mark M.
100% (3)Projects Completed
3
Freelancers worked with
2
Projects awarded
75%
Last project
27 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
your attachment XML file does not appear to have any style information associated with it. it isn't open
894781
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