update excel macros & VBA code
$10-30 USD
Paid on delivery
front end: drop down lists "new name" and "old name" to be arranged alphabetically and eliminate blank spaces, eliminate duplicates
front end: legal ID drop down list to be in ascending numerical order (eg: 1, 2, 3, 4,… )
NEW front end: incorporate all changes in "front-end" tab to look like "NEW front end" tab
New front end: period (H11) should have two options: 0, 1 (0 needs to display as "0")
New front end: "new name" should populate based on mapping table (column F), "underlying" should populate based on mapping table (column G)
Record: add a column with the user's email that they used to send out OR the user's windows ID
Record: add a column with a timestamp when they submit
Record: separate "new name" and "underlying" into two different columns
add password to tabs "mapping" "back end" "record" so only with the password can the user open and look at it (also hide these 3 tabs)
NEW Back end: please arrange "back-end" to look like this new tab
NEW back end: A1:L35 to be exported to PDF
front end: Legal ID, trade date, period, amount must be inputed/ chosen by the user, otherwise submit gives error message "please fill in all required fields"
record & back end: elminate "period check"
**note** I added another row in mapping
New front end & New back end: "trade date 2" = "result from G13" + "result from J13" ex: "13/11/2017 +1"
New front end & New back end: "period 2" = "result from G13" + "(result from J13 + result from mapping column K) ex: (if legal ID 5443 is chosen & a period of 1 is chosen) "13/11/2017 + 3"
Please see attached document and let me know if you have any questions.
Project ID: #15375977
About the project
Awarded to:
12 freelancers are bidding on average $34 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia More
i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now. Relevant Skills and Experience I am very familiar and strong knowledge of VBA. Proposed Milestone More
In one day I can develop the vba code you're asking for Relevant Skills and Experience I'm an excel pro user Proposed Milestones $25 USD - Whole project