Macro Update

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

Updates required to existing macro

1. Change header for column AS on constituent output from C AttrCat (remove space) to CAttrCat

2. Change output value for column R in constituent output from 48 to 2

3. Change output value for column AD on action output from Email to Yes

4. Change output value column E action output from Task to Task/Other

5. Change output value for column G action output from Complete to Completed. Pending will remain as is.

6. Change output value for column AC on constituent output from FL_Region (DHA) to Region (DHA)

7. Change output value for V & AH on constituent output from Direct to Direct Referral

8. Change output value for D on action output from FLR_PWD Information to FLR_Demographic Information

9. Insert a column on input spreadsheet after column B

i. Header = Referral Source

ii. Drop down values

1. Primary/Specialized Care

2. Home/Community Care

3. Acute Care

4. Long-Term Care

5. Other

iii. Add to action output for lines where ACType = FL_Direct Referral. Can be added to column AJ-AM

1. AJ - Value = Assign unique value to all records. First value CA7-221124-01, second record will be CA7-221124-02. YY=current year MM =current month DD=current day

2. AK- value = FLR_Direct Referral Source

3. AL - CAttrDesc, value selected from new drop down above Referral Source

4. AM - CAttrDate, value = Same value as referral date

10. Add solicitors to drop down – see spreadsheet PS Staff Import Id’s

i. Update column W on input spreadsheet with values in column a

ii. Update column C values on action output

11. Update Diagnosis drop down with values in excel file ‘Diagnosis Table’

12. Update DHA drop down with values in excel file ‘Regions’

13. Add a column after column G ‘AcStatus’, header = AcComplete with the value of true for records where ACStatus equals complete

Excel Excel Macros

Project ID: #35324318

About the project

43 proposals Remote project Active 1 year ago

Awarded to:

(159 Reviews)
7.5

43 freelancers are bidding on average $140 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you More

$220 CAD in 4 days
(507 Reviews)
8.4
P0L

Hello, I am an Excel/VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.

$250 CAD in 3 days
(489 Reviews)
8.0
bouslimi1979

Hello, can you please share the file with macros ? the task description is very clear but I need to check the file. Thanks

$200 CAD in 3 days
(322 Reviews)
7.8
AccountantArman

""""""""""""""""""""""""""""""""""""""EXCEL MACRO EXPERT"""""""""""""""""""""""""""""" "SIR", I am EXCEL MACRO VBA CODING Advanced Level Expert. This is basic work for me. I can complete this project with added qualit More

$99 CAD in 1 day
(205 Reviews)
6.8
NIKITALILA

"Hi there, I can definitely help you with your Excel work. We can do a quick zoom meeting to understand your requirements better. We are a team of trained professionals with years of experience in Bookkeeping, MS E More

$199 CAD in 7 days
(48 Reviews)
6.4
PERPETUAL0

Hello there Iam excel EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t More

$124 CAD in 2 days
(173 Reviews)
6.0
hamidr2020

Hello, I am an Excel and VBA/Macro expert. I have read the 13 requirements regarding the macro that needs to be updated. I offer my services to update the macro accordingly. You can check my reviews for quality of wor More

$155 CAD in 2 days
(75 Reviews)
6.0
WelcomeClient

Hi There, I'm ready to update Macro and able to perform all mention 13 instructions. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me More

$100 CAD in 1 day
(80 Reviews)
5.3
MamukaB

Hello, I have read project details . I can help with this project. I have 15+ year experience in Excel, Excel VBA, Python and have 100% feedback You can trust, result will be excellent Best Regards

$80 CAD in 2 days
(42 Reviews)
5.0
umairnoor32

Hello Sir, I have read your instructions and I can do it efficiently. Please give me this project. i will never disappoint you regarding your work and I will give you unlimited revisions with 100% quality work. Thank More

$95 CAD in 2 days
(22 Reviews)
3.3
alamineee

Hi, Dear Employer, I am Al.A. I am a Ph.D. backgrounder and professional data scraper. I will provide you high-quality Excel file. I have worked on similar projects of excel/CSV/Excel Macros and can deliver professiona More

$140 CAD in 2 days
(4 Reviews)
3.4
vw1514518vw

Ready to update the macro as described 13 points , on 3 milestone payment as follows" # milestone for point 1 to 9 ($100 # milestone for points 10 to 13 ($100) # feedback changes , test and final delivery ($50)

$250 CAD in 3 days
(5 Reviews)
3.1
nguyentuan90

Hi, How are u? I have full experience with Excel, Macros... I've a great skill in this fields. I am always working about all task perfectly. I can complete your project with high quality on time. Looking forward to hea More

$140 CAD in 7 days
(1 Review)
2.9
TopWritingGuru

My name is Rabia Faisal, I am working in the writing industry since 2011. In this time, I have served countless clients with full amount of satisfaction by providing them TOP Quality Solutions. I have command on all re More

$30 CAD in 1 day
(1 Review)
1.2
santiagomac841

Dear client! My name is Santiago from Spain and I am machine learning with Spss, Scraping with python, google sheet & Business Analyzer of Solar Energy-Car Market. I have 5 years of experience in excel, business and f More

$140 CAD in 7 days
(1 Review)
0.6
benkushau

If you need anything done in excel or google sheets, you have got to the right place! I have been working with excel and google sheets for the last 6 years with 800+ projects completed. 100% Customer satisfaction guara More

$140 CAD in 7 days
(0 Reviews)
0.0
Jeanphilippe38

Hi, I can make a macro ding what you ask within 3 days at low price. Contact me if knterested Thanks, Jpa

$30 CAD in 3 days
(0 Reviews)
0.0
tkmaina868

ESTEEMED CUSTOMER! I can perfectly do the Macto update I make sure my clients are 100% satisfied with the writings. I am a professional writer with proven track record. You can also see my reviews as well Thank Yo More

$140 CAD in 1 day
(1 Review)
0.0
dipanshupandit52

I have more than 5 years experience in web designing, Logo making, content writing, copy writing, proof reading, typing, translation, voice over, shopify expert, Data scraping. Having good typing speed, knowledge of re More

$140 CAD in 7 days
(0 Reviews)
0.0
apshilwant20

Hi, I would like you to work on your project. I am having around 5+ years of experience in this domain. I am an automation Specialist using VBA, SQL, R and Python and Visualisation using Power BI, Qlik and Tableau. More

$100 CAD in 2 days
(0 Reviews)
0.0