Request details
Essentially here's what I am trying to get the code to do:
Examine a list of cells in Column A, Sheet1.
For each cell, cross reference the text string (has to match entire cell contents) with a huge list of data in Column B, Sheet2.
There will be anywhere from 0 to 5 duplicates found.
If 0 duplicates are found, write "X" in Column B, sheet1, in the same row as the cell being examined.
Now, if a duplicate found in column B (sheet2), concatenate the contents of columns C and D (in the same row), and put the resulting string one cell to the right of the original cell being referenced (sheet1).
For each additional duplicate, do the same thing, and put each subsequent concatenated string in the same row, one column to the right of the previous one.
I hope this explanation is clear. I will provide a sample of the data.
Deliverables
Vba code
Greetings!
Thanks for very clear explanation of requirements - I understand the same. I can develop a macro exactly as per requirements. Please share the file.
Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Typically, I spend at least 200 HOURS on automation in Excel every month.
Have a Great Day!
Srinivasan Krishnamoorthi
Hi,
I have read your requirements and I am very interested in this project. I have 6 years of experience in this field so I can do this for you at reasonable price. Please feel free to contact me.
Portfolio: www.freelancer.com/u/marfan080
Regards,
Junaid Afsar
MS Office Expert
Hi,
I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me.
Thanks.
Hi,
Greetings!
✅Checked your project details: VBA project with Excel
✅Completed Time: 24 hours or your required deadline.
Kindly, I work on many projects like your request,
I can send you many samples of my work in Excel charts, Formulas, Pivot tables, and VBA codes.
Please let me have a chance to show you my experiences.
✅My Portfolio Items:https://www.freelancer.com/u/Blackeagle8
Thank you
Hazzaa
I understood your requirment and can start now and will deliver solution fast.
Hire only if your are satisfied with the demo of solution provided by me.
I am professional Excel and VBA developer (6+ years of expeience)
**Works full time on Saturday and Sunday as freelancer.
**Have a look at my profile
https://www.freelancer.in/u/imaditya92
Regard
Dear Sir/Madam,
I would love to assist you as after reading the complete project description carefully! i found myself as the best match for your requirements.
i’m EXCEL expert , having more than 5 years of experience in VBA EXCEL, Data Entry, coding with Visual basic or C language programming etc
Please review my profile, if interested contact me soon!
Thanks!
Michael
I am an expert in the Microsoft Excel environment with 10+ years of experience, using formulas and VBA to create innovative solutions is part of my day to day work.
Hi, Dear!
I have a full experience of 7 years in Excel VBA.
I have read your requirement carefully and I am interested in this project.
If you`ll choose me, I am confident to provide you best solution
that completely satisfy your business needs in time.
Looking forward to discuss with you soon.
Thanks & Best regards!
Hello
Your explanation is very clear and straightforward. Some simple questions:
When you say huge list, do you mean how many rows?
It would be ok if we put a nice button to trigger the execution of the task?
Best regards
Hello!
I saw this post that you need a VA for your VBA PRoject. Well, here I am!
My name is Yhana and I'm 33 years old. A VA from the Philippines. I firmly believe that I can contribute a lot of my skills to your team especially when it comes to your Data entry needs and other related tasks.
Here’s what I can do for you:
• Data Entry
• Email Management
• Research
• Converting Files
• Google Docs and Sheets, MS Office, PDF, Canva
• Sorting
• etc.
I’ve gained knowledge a lot because I've been a Secretary and an Admin. Assitant for 13 years so I am confident that I can deliver the quality results that you need!
Sounds great?
Let me know if you want to chat or call so we can discuss!
Have a great Day!
+639956106192
Good day!
Cool task. Our team offers to do it for free for review.
Note:
The term of the order is conditional.
The exact term of the order - we will inform you after the agreement and approval of the Terms of Reference.
Regards, Alek Rasly
Hi, I'm interested working in this kind of task and I can guarantee accuracy with a less than 24 hours turn around time. I can do sample work for free when needed. Thanks!
I have understood the requirement and should be able do complete it in 2 days (may be less) . I have 15 years of experience with excel, vba , data processing and data entry and worked for many corporates in this field. I am looking for some extra money during my freetime
Hello good Morning!
Are you all right? I hope so !!
First let me introduce you. My name is João, I am programmer and developer, I have advanced Excel, Vba, C and Power Bi courses.
I currently work for a company where I do automation and development of spreadsheets, web applications and powerbi dashboards.
Let's talk?