One small excel formula to be written
- or -
Post a project like this3099
$
- Posted:
- Proposals: 9
- Remote
- #917341
- Completed
Admin Support ; Data Collection ; Data Entry ; Web Research; Linkbuilding; Excel; Word & PDF, Photo Editing
Karachi
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
64162220827031500265299274541191112495618396369211341
Description
Experience Level: Entry
Description of excel work: I need a formula to be written into the attached .
So Basically I want it to do the following:
Every Date of arrival that is placed on the 'income sheet' needs to populate the cleaning and laundry cells of the corresponding date in each of the corresponding expenditure sheets. Cleaning needs to be populated with 20 and laundry needs to be populated with 10.
I .e. If I recieve a booking in 4 Greenmount on the 1st of October this date is entered into the income sheet.
Automatically Cleaning is changed to 20 and laundry 10 on the 4 Green mount Expenditure sheet.
For example
If the 1st of october is placed as an arrival date in 4 greenmount lane then 20 needs to be placed in the cleaning cell of the 1st of october on the 4 Greenmount Expenses sheet. 10 will also need to be placed in the same row but under laundry.
That may be unclear and Im pretty sure its next to impossible so dont worry about it if ya cant find a solution easily :0)
Please find the spreadsheet attached
Extra notes:
So Basically I want it to do the following:
Every Date of arrival that is placed on the 'income sheet' needs to populate the cleaning and laundry cells of the corresponding date in each of the corresponding expenditure sheets. Cleaning needs to be populated with 20 and laundry needs to be populated with 10.
I .e. If I recieve a booking in 4 Greenmount on the 1st of October this date is entered into the income sheet.
Automatically Cleaning is changed to 20 and laundry 10 on the 4 Green mount Expenditure sheet.
For example
If the 1st of october is placed as an arrival date in 4 greenmount lane then 20 needs to be placed in the cleaning cell of the 1st of october on the 4 Greenmount Expenses sheet. 10 will also need to be placed in the same row but under laundry.
That may be unclear and Im pretty sure its next to impossible so dont worry about it if ya cant find a solution easily :0)
Please find the spreadsheet attached
Extra notes:
Senan C.
99% (57)Projects Completed
48
Freelancers worked with
39
Projects awarded
42%
Last project
29 Mar 2024
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