Excel Template that automatically populates cells
- or -
Post a project like this2249
$
- Posted:
- Proposals: 12
- Remote
- #1874890
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Virtual assistant, Researcher, Photoshop, Email handling, Data Entry and Admin support
Caraga
19919997539391394015140641614494731467017161757618958641929931194579119812531991037
Description
Experience Level: Entry
I need an excel spreadsheet template set up so that when a cell is populated with a number 1 it auto populates the remaining row 1 to 22
Row 1 and 2 leave to be manually populated
Row 4 - Manual enter of 1 and 2 to 22 will be auto populated across the row (This row is the set target programme)
Row 5 - Manually inputted each week. If the 1 is entered before or after the top row number 1 then this square is to be coloured. then each week the last number entered will be coloured either Red if it is behind the top line or Green if in Front, Yellow if matched
Even number row will be target and 2 to 22 to be auto populated. If the column going down is greyed out (Xmas period then the number is to break here and carry on after the greyed out.
Please see the attached template as to what I need
I require this ASAP
Row 1 and 2 leave to be manually populated
Row 4 - Manual enter of 1 and 2 to 22 will be auto populated across the row (This row is the set target programme)
Row 5 - Manually inputted each week. If the 1 is entered before or after the top row number 1 then this square is to be coloured. then each week the last number entered will be coloured either Red if it is behind the top line or Green if in Front, Yellow if matched
Even number row will be target and 2 to 22 to be auto populated. If the column going down is greyed out (Xmas period then the number is to break here and carry on after the greyed out.
Please see the attached template as to what I need
I require this ASAP
Natalie C.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
9%
Last project
31 Jan 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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