Excel Lookup Table, Duplication and Appending
$15-25 USD / hour
My experience has been search for solutions and then "reverse engineer" the code to fit my needs. I stumble when it comes to For/Next looping and Lookup Table manipulation.
My Workbook has two main worksheets - Master and NameLU. A person's first name can be variable. I want to have VBA which will do the lookup for a match between the Master and Lookup tables, duplicate the Master table record up to 5 times depending on a count in the Lookup table, and then replace the first name with a variation. E.g.: RICHARD could also be known as Rich, Dick, Ricky, or Rick. I would like the additional 4 name variations, and the result appended to the Master table. The Master table may have 300-1000 records to loop through.
I am attaching a more visual explanation.
Project ID: #37385842
About the project
35 freelancers are bidding on average $20/hour for this job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Hello, my name is Andrii and I am an experienced Excel data scientist, statistician, analyst, social researcher and academic projects specialist. I understand your project needs to find a solution for your Excel lookup More
Hello there! My name is Akriti and I'm a professional Excel expert with extensive experience in the areas of Excel VBA and automation. When it comes to your project description for Excel lookup table, duplication and a More
--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, More
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc More
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. I’m Ahmed Hassanein. I’ve been working wi More
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports More
Greetings, I am excited to propose a solution for your unique challenge. With my extensive experience in reverse engineering and VBA programming, I am confident in my ability to create a tailored solution for your Wor More
Hey sir, it seems that you want to do some reverse engineering processes in VBA such as lookingup for matching values between 2 worksheets and doing some duplicates with variations. We can do that easily using VBA in More
Hello, My name is Sunil and I am a professional and experienced Excel expert. I have extensive knowledge in graphics design, photoshop, Adove illustrator, Indesign and Microsoft VBA. I understand your project needs l More
Hello sir I am Anas, a data analytic with very good skills in data visualization including dashboard with both static and dynamic graphs in Power Bi, Excel and Google Data Studio. So I can achieve this task perfectly, More
Hi, I am interested in this project and i am ready to do it for you. To proceed further, I am ready to discuss your project and start immediately. Thanks
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 More
I am a data entry expert. I am possess a strong attention to detail and have a good understanding of different software tools and techniques used in data entry. I expertise in data entry allows to efficiently handle la More
Greetings! I understand that you are looking for someone to create an Excel lookup table duplicating up to 5 times depending on a count in the Lookup table, replacing the first name with a variation, and then appendi More
"Hello, I am Raveesh Sulakshana, a seasoned professional with a strong expertise in Microsoft Excel. With 3 years of experience in various roles, I have honed my skills to an advanced level, making me proficient in cre More
Hi Sir, I am Neha Kumari From Bangalore and i am working Systunix private limited as an Data Analyst from Bangalore and Also i am interested for this work c so can you give me this work. Thank You Neha kumari.
