Đã hoàn thành

Insurance Excel Macro / VBA

Requirements for macro enabling:

Currently there are formulas in the template for valuing Col D3:D each Rec Type Tab (Transmission -> Event, not including Transmission and Audit)

1) Insert Tab where user

a. Selects prod/service

i. Values will be: Financial Wellness; Term Mailing/PruPassages; Disability Only; Disability & Absence; Voluntary; EOI

b. Enters Customer Name & Control#

2) Macro will do the following to the template to create an updated layout

a. Remove/Hide the tab or userform where user entered data

b. Remove/Hide tab ‘Revisions’

c. Update tabs (Customer Contact Details; Data Exchange Key Dates) with the Customer Name and Control#

d. Each tab (Associate – Event, not including Audit) has columns K-V with data in them (blue colored cells) These columns represent each Product chosen in 1ai and their respective comments. IE For Financial Wellness Column K refers to Financial Wellness and Column L represents comments for Financial Wellness for all applicable tabs

i. Col K, L for FW

ii. Col M, N for Term Mailing

iii. Col O, P for Disability

iv. Col Q, R for Absence

v. Col S, T for Voluntary

vi. Col U. V for EOI

e. If a product is NOT chosen in initial User form its respective columns on all tabs must be deleted. What this will do is directly update the value in D3 because of the conditional formula.

i. IE if only Financial Wellness was chosen as the product then on the Coverage tab columns M-V would be deleted. This would then update the value in D3 to be N.

ii. Keep in mind that more than 1 product could be chosen IE Financial Wellness and EOI could be chosen.

iii. Once NOT chosen products are deleted D3:D should be copied and pasted to D3:D with Values instead of formulas so they become static

f. Tabs should then be hidden based on the value for cell D3, if the cell is valued with N the tab should be hidden if it is value with anything else it should remain unhidden.

g. Update tabs (Transmissions – Event) that remain for field named ‘Client Control Number’ with the Control# entered by user in H4

h. Update Transmission (Header) Rec Type for field ‘Client Name’ with the Customer name entered by user

i. Update Audit (Trailer) Rec Type

i. If a record type is NOT required default Column D to N and Comments (Column H) to Null

ii. If a rec type is required update Column D to Y

iii. If a rec type if R Conditionally update Column D to R Conditionally

iv. If all columns = O value O

j. For each Tab (Transmission – Event) that remains

i. If there is a comment valued in Columns L; N; P; R, T and/or V - move values to column called ‘Comments' (Column H)

1. If more than one column has value; add comment on separate line within the SAME cell values are being written to

2. Keep existing Data in Cells H:H, just append the new comments from L,N,P,R,T,V onto a new line in the cell

3. If all remaining Blue cells for K:K, M:M, O:O, Q:Q, S:S, U:U are N and that respective H cell has no value r data in it then value respective H cell with “Null”

a. IE Row 15 on Coverage tab, all Values for H,L,N,P,R,T,Vare N so H15 would be valued “Null”

b. KEEP IN MIND ALL PRODUCTS MAY NOT BE HERE AT THIS POINT AS YOU HAVE ALREADY DELETED PRODUCTS NOT CHOSEN…

k. Delete Columns J-V for each Rec Type tab

Macro should be created in a way that if more Products or more Rec Type Tabs Transmission – Event) are added in the future the code useful / easy enough that it can be modified to add that criteria.

Kĩ năng: Excel VBA, Excel Macros, Excel, Excel VB Capabilities

Xem nhiều hơn: microsoft excel print invoice macro, excel lock fields macro, excel vba repeat macro times, excel top ten macro script visual basic, excel find display macro, excel add row macro ask fill cells, copy excel paste web macro, excel print invoice macro, excel turn spreadsheet macro, excel word vba macro example, excel visual basic macro download yahoo stock prices, excel invoice number macro, excel install add macro menu, data entry contact details entered excel spreadsheet

Về Bên Thuê:
( 0 nhận xét ) Jersey City, United States

ID dự án: #30637567

Được trao cho:

(295 Đánh Giá)
6.4

25 freelancer chào giá trung bình$187 cho công việc này

(817 Nhận xét)
8.8
(404 Nhận xét)
8.2
P0L

(474 Nhận xét)
8.0
(353 Nhận xét)
8.0
(397 Nhận xét)
7.6
(300 Nhận xét)
7.3
(220 Nhận xét)
7.0
(112 Nhận xét)
6.9
(118 Nhận xét)
6.6
(35 Nhận xét)
6.2
(161 Nhận xét)
5.9
sajibdigital

"Hi, I am interested in your project. I hope you will be happy after hiring me. Can we discuss more details about this project? Thanks"

$100 USD trong 3 ngày
(66 Nhận xét)
5.7
(53 Nhận xét)
6.0
kingqueen369

Hi, Greetings! ✅checked your project details :Insurance Excel Macro Attachments Ashish_DRAFT Single File [login to view URL] ✅Completed Time : 24 hours or your requirement deadline . I would like to work Thêm

$50 USD trong 1 ngày
(65 Nhận xét)
5.5
(28 Nhận xét)
5.4
(14 Nhận xét)
5.6
(28 Nhận xét)
4.7
(63 Nhận xét)
4.9
mzdesmag

Hi, I’m an experienced analyst information researcher, and science scholastic author. I have complete some Ph.D. level postulation activities, including progressed factual examination of information. Scanning for remar Thêm

$140 USD trong 3 ngày
(7 Nhận xét)
4.3
(3 Nhận xét)
2.8