Find Jobs
Hire Freelancers

Create an Excel macro

£20-250 GBP

Folyamatban
Kiadva ekkor: több mint 4 évvel ezelőtt

£20-250 GBP

Teljesítéskor fizetve
I have a spreadsheet with multiple columns. The cells in one column can have multiple entries, separated by a comma. I want to create a new tab putting each of these entries into a separate row. The current document just has the tabs ‘ICSRs’ and ‘Lists – Do not delete!’. What I need is a macro to produce the ‘AE listing’ and possibly the ‘AE count’ pivot table. The ‘AE listing’ needs to take the ‘Case Id No.’ and the ‘Adverse event(s) (LLT)’ data and to produce a single row per adverse event. If you look at the 2nd, 4th and 5th case in the ‘AE listing’ tab, they have multiple adverse events, all separated by a ‘,’. I have manually created the required listing in the ‘AE listing’ tab. See the attached sample file.
Projektazonosító: 22109980

A projektről

33 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
33 szabadúszó adott átlagosan £79 GBP összegű árajánlatot erre a munkára
Felhasználó avatár
" I am expert in Microsoft Office specially Excel, Word and Access Database. Data Entry and Processing is my passion with years of experiences. I am talented and very hard working also know the value of time so, always try deliver work on time. My motive is to make my employer happy with quality of service. For data entry work I promise to deliver you the best of best services "
£40 GBP 1 napon belül
4,9 (316 értékelés)
7,5
7,5
Felhasználó avatár
Hi I am Excel VBA expert using Excel since 2003. What I understood is that you will have ICSRs sheet only and the macro should create 'AE Listing' and 'AE count' Sheets. AM I right? Please let me know.
£135 GBP 4 napon belül
5,0 (386 értékelés)
7,6
7,6
Felhasználó avatár
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£50 GBP 1 napon belül
4,9 (353 értékelés)
7,4
7,4
Felhasználó avatár
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will split the data in column P to separate rows as shown in the AE Listing tab. I plan to use VBA code to accomplish this. The Excel file will run on PCs. I will charge you 70£* and can deliver within a few hours (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 330 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
£70 GBP 1 napon belül
4,9 (255 értékelés)
7,5
7,5
Felhasználó avatár
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. It seems quite simple, I can write a macro to create what you need. Write me to define the details. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
£50 GBP 1 napon belül
4,9 (247 értékelés)
7,0
7,0
Felhasználó avatár
Dear client I understand the scope of work involved in the project. I can write the script in macro which will solve the purpose. Kindly contact me. Roy
£100 GBP 2 napon belül
4,9 (364 értékelés)
6,9
6,9
Felhasználó avatár
Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi
£135 GBP 7 napon belül
4,9 (123 értékelés)
6,4
6,4
Felhasználó avatár
Hi, If you can see what your project on writing an Excel macros that will produce pivot for the ‘AE listing’ and possibly the ‘AE count’ taps of your Excel workbook will turn out to be, even before you award it, you’ll be confident you have picked the best hands for your project. Fortunately, that’s exactly what I’m set to do. I want to complete a part of your project as a proof of concept before you award the project. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£200 GBP 7 napon belül
4,9 (57 értékelés)
6,5
6,5
Felhasználó avatár
Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.
£75 GBP 2 napon belül
4,9 (91 értékelés)
6,0
6,0
Felhasználó avatár
Hi, I have understand the project requirement & interested to make text separator macro for this project. Please send a message so we can discuss more & start the project. Thanks.
£25 GBP 1 napon belül
5,0 (113 értékelés)
5,6
5,6
Felhasználó avatár
Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
£98 GBP 2 napon belül
4,7 (103 értékelés)
6,2
6,2
Felhasználó avatár
Hello, I have taken a look at the file and instructions and this is really easy for me to do. I can start now. If you open a chat with me and give me go ahead, I will provide the work in max 1 hour. Kind regards, Sorin
£20 GBP 1 napon belül
5,0 (59 értékelés)
5,3
5,3
Felhasználó avatár
£ 20.00 Only ------ In just 3 Hours ------ Excel Data Entry, VBA Macro Coding, Automation, Formula Generation, Chart and Graph Expert
£20 GBP 1 napon belül
5,0 (82 értékelés)
5,0
5,0
Felhasználó avatár
Hi there I can automate the splitting of the data based on “,” and unstack it into new rows. You may see a sample data unstacking work which is very similar to you requirements in my freelancer profile page. Please message me if that is any of what you need. I’ll be standing by to help
£66 GBP 2 napon belül
5,0 (15 értékelés)
4,6
4,6
Felhasználó avatár
Hi, I can write such Macro for you. The macro will go through all "Adverse Events(s) (LLT)" and extracts each entity (which is separated by comma), and then place each entity into the "AE Listing" along with is "Case id No", at the end your pivot table will be refreshed
£100 GBP 1 napon belül
5,0 (12 értékelés)
4,4
4,4
Felhasználó avatár
Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in excel vba and macro writing. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
£50 GBP 2 napon belül
5,0 (10 értékelés)
3,8
3,8
Felhasználó avatár
I understand your requirement, you want to count "Adverse event(s)(LLT)" in column P. I tested with VBA already, actually I finished your requirement. Nausea = 26, Shortness of breath = 20, Headache = 19, Vomiting = 19, .. so on. Please feel free to chat me. Thank you very much. Witoon
£20 GBP 1 napon belül
5,0 (7 értékelés)
2,7
2,7
Felhasználó avatár
Hi dear sir/madam, I'm very active and interested to work with you. My time up to you. I have many experience in this case and you could award your project to me and enjoy it. With best regards
£20 GBP 1 napon belül
5,0 (3 értékelés)
1,8
1,8
Felhasználó avatár
Our Profile : https://www.freelancer.pk/u/SpacerMedia?w=f Hi! I hope you are well there is my offer as per your request, I have READ and UNDERSTOOD the requirements. We are Media Group working for almost 4 years in Pakistan , but new to Freelancers. We have a team of professionals, we can assure you that your work will be done asap as per your requirements. we will provide you top quality work with in the deadline. Looking forward for your response. I am confident to delight you. Thanks & Regards Fazila Syed Project Manager Spacer Media Group
£20 GBP 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello Sir/Madam, My name is FATIMA and writing is my passion “When I say work, I only mean writing. Everything else is just an odd job”. From my early age, I enjoyed reading novels and stories, as I was growing up it has become my passion now. I am professionally active in the field of writing since 2010 for my clients on different platforms. Thank you
£20 GBP 1 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

UNITED KINGDOM zászlója
Easterton, United Kingdom
5,0
1
Fizetési mód hitelesítve
Tagság kezdete: nov. 2, 2019

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.