Excel macro programming
- or -
Post a project like this3783
£30(approx. $38)
- Posted:
- Proposals: 6
- Remote
- #374145
- Awarded
Logo , Web designer,HTML5,CSS3WORDPRESS,Adobe ilustrator-vector design, Adobe indesign, Adobe photoshop,EXCEL.
Banja Luka
Writer, Proofreader, Virtual Assistant, Transcriber, Data Scientist and PhD in Computational Biology
London
548700529525531553549184561286563802
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Individual
Kind of development: New program from scratch
Description of requirements/functionality: Need an Excel macro for populating values.
** The procedure for populating standard cost is as follows: There will be two tabs "Invoice posting date" and "Standard Cost" in the spreadsheet.
1. Take the Invoice posting date and the Product above.
2. For each of the Product above, take the Invoice posting date and compare it against the Last update time from the tab "Standard cost".
3. Pick the standard costs from the line where the Invoice posting date >= Last update date in tab "Standard cost". If there are more than one update time for the same date, then pick the cost from the latest time and ignore the earlier ones.
4. If there are no costs for that product populate 0.00 in the Standard cost column above (tab "Invoice posting date).
Extra notes:
Kind of development: New program from scratch
Description of requirements/functionality: Need an Excel macro for populating values.
** The procedure for populating standard cost is as follows: There will be two tabs "Invoice posting date" and "Standard Cost" in the spreadsheet.
1. Take the Invoice posting date and the Product above.
2. For each of the Product above, take the Invoice posting date and compare it against the Last update time from the tab "Standard cost".
3. Pick the standard costs from the line where the Invoice posting date >= Last update date in tab "Standard cost". If there are more than one update time for the same date, then pick the cost from the latest time and ignore the earlier ones.
4. If there are no costs for that product populate 0.00 in the Standard cost column above (tab "Invoice posting date).
Extra notes:
Raja V.
100% (3)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
2 Mar 2015
United States
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