Đang Thực Hiện

update excel macros & VBA code

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.

Kỹ năng: Excel, Microsoft Access, Kiến trúc phần mềm, Visual Basic, Visual Basic cho Ứng dụng

Xem thêm: how to save vba code in excel, excel module function, how to run vba code in excel automatically, vba code examples, insert module excel 2013, run vba code in excel, how to run a macro in excel 2010, excel vba add code to worksheet programmatically, excel clean vba code, excel solver vba code, excel amibroker vba code, powerpoint macros vba code, job freelance excel macros vba, import table excel sheets vba code, import excel access vba code

Về Bên Thuê:
( 1 nhận xét ) Toronto, Canada

Mã Dự Án: #15375977

Đã trao cho:

mrojas400

More than 20 years of excell vba experience.

$22 USD trong 5 ngày
(0 Đánh Giá)
0.0

16 freelancer đang chào giá trung bình $32 cho công việc này

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 Thêm

$70 USD trong 3 ngày
(180 Đánh Giá)
6.7
$25 USD trong 1 ngày
(10 Đánh Giá)
4.7
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 Thêm

$100 USD trong 3 ngày
(24 Đánh Giá)
4.2
AKABLIRADOUAN

hi please feel free to contact me for more details. I am good at VBA.

$18 USD trong 3 ngày
(1 Đánh Giá)
1.4
frankrui

A proposal has not yet been provided

$15 USD trong 1 ngày
(1 Đánh Giá)
0.5
$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
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 Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
maximwang8661

If you hire me, I can start working for you right now. Relevant Skills and Experience VBA Proposed Milestones $25 USD - 1

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
tuanthanhle

A proposal has not yet been provided

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
hazrat270

A proposal has not yet been provided

$15 USD trong 10 ngày
(0 Đánh Giá)
0.0
angelosantitto

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

$35 USD trong 2 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
0.0
whitehorsetechn

Greeting, I have understood your update excel macros & VBA code task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experien Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
aajaysuryawanshi

A proposal has not yet been provided

$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
Leoagil2017

A proposal has not yet been provided

$35 USD trong 30 ngày
(0 Đánh Giá)
0.0