Find Jobs
Hire Freelancers

Create an Excel macro

£20-250 GBP

Igangværende
Slået op over 4 år siden

£20-250 GBP

Betales ved levering
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.
Projekt-ID: 22109980

Om projektet

33 forslag
Projekt på afstand
Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
33 freelancere byder i gennemsnit £79 GBP på dette job
Brug Avatar.
" 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 på 1 dag
4,9 (316 anmeldelser)
7,5
7,5
Brug Avatar.
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 på 4 dage
5,0 (386 anmeldelser)
7,6
7,6
Brug Avatar.
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 på 1 dag
4,9 (353 anmeldelser)
7,4
7,4
Brug Avatar.
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 på 1 dag
4,9 (255 anmeldelser)
7,5
7,5
Brug Avatar.
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 på 1 dag
4,9 (247 anmeldelser)
7,0
7,0
Brug Avatar.
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 på 2 dage
4,9 (364 anmeldelser)
6,9
6,9
Brug Avatar.
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 på 7 dage
4,9 (123 anmeldelser)
6,4
6,4
Brug Avatar.
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 på 7 dage
4,9 (57 anmeldelser)
6,5
6,5
Brug Avatar.
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 på 2 dage
4,9 (91 anmeldelser)
6,0
6,0
Brug Avatar.
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 på 1 dag
5,0 (113 anmeldelser)
5,6
5,6
Brug Avatar.
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 på 2 dage
4,7 (103 anmeldelser)
6,2
6,2
Brug Avatar.
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 på 1 dag
5,0 (59 anmeldelser)
5,3
5,3
Brug Avatar.
£ 20.00 Only ------ In just 3 Hours ------ Excel Data Entry, VBA Macro Coding, Automation, Formula Generation, Chart and Graph Expert
£20 GBP på 1 dag
5,0 (82 anmeldelser)
5,0
5,0
Brug Avatar.
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 på 2 dage
5,0 (15 anmeldelser)
4,6
4,6
Brug Avatar.
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 på 1 dag
5,0 (12 anmeldelser)
4,4
4,4
Brug Avatar.
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 på 2 dage
5,0 (10 anmeldelser)
3,8
3,8
Brug Avatar.
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 på 1 dag
5,0 (7 anmeldelser)
2,7
2,7
Brug Avatar.
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 på 1 dag
5,0 (3 anmeldelser)
1,8
1,8
Brug Avatar.
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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED KINGDOM
Easterton, United Kingdom
5,0
1
Betalingsmetode verificeret
Medlem siden nov. 2, 2019

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.