Macro Update
$30-250 CAD
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
Project ID: #35324318
About the project
Awarded to:
43 freelancers are bidding on average $140 for this job
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
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.
Hello, can you please share the file with macros ? the task description is very clear but I need to check the file. Thanks
""""""""""""""""""""""""""""""""""""""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
"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
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
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
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
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
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
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)
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
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
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
Hi, I can make a macro ding what you ask within 3 days at low price. Contact me if knterested Thanks, Jpa
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
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
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