update excel macros & VBA code

In Progress Posted 6 years ago Paid on delivery
In Progress 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.

Excel Microsoft Access Software Architecture Visual Basic Visual Basic for Apps

Project ID: #15375977

About the project

12 proposals Remote project Active 6 years ago

Awarded to:

mrojas400

More than 20 years of excell vba experience.

$22 USD in 5 days
(0 Reviews)
0.0

12 freelancers are bidding on average $34 for this job

elqueabandona

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

$70 USD in 3 days
(304 Reviews)
7.3
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i More

$100 USD in 3 days
(31 Reviews)
4.5
tuanthanhle

A proposal has not yet been provided

$30 USD in 1 day
(11 Reviews)
3.8
frankrui

A proposal has not yet been provided

$15 USD in 1 day
(3 Reviews)
1.6
krylovxiao

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

$25 USD in 1 day
(0 Reviews)
0.0
hazrat270

A proposal has not yet been provided

$15 USD in 10 days
(0 Reviews)
0.0
angelosantitto

Seems like a very straight forward request. Thanks for the opportunity.

$35 USD in 2 days
(0 Reviews)
0.0
atengsolutions

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

$25 USD in 1 day
(0 Reviews)
0.0
aajaysuryawanshi

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0