Build VBA script to match, copy and delete information
$12-30 SGD
Paiement à la livraison
1) Compare Sheet3 Column A (row 1) with Sheet 2 Column D and if Sheet 3 Column B (row 1) is "DNC/NR",
delete matched row on Sheet 2.
2) Remove all empty rows
3a) Compare (Sheet 2 Column A with Sheet 1 Column H) and (Sheet 2 Column B with Sheet 1 Column G),
if two matches, copy matched row for Sheet 2 Column C and D to Sheet 1 Column I and J
b) If matched results has multiple names and numbers, add on Sheet 1 Column K and J and so on
4) Return filtered result which has all the columns filled from A to J for Sheet 1 as final ouput
Any questions, feel free to ask
Nº du projet : #16631143
À propos du projet
6 freelances font une offre moyenne de 25 $ pour ce travail
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can dev Plus
I am very profesional on Excell. I have done many data processing project by using VBA code that I can show you. This solution will reduce mistake and faster than human doing. I also can create very cute template Plus
Hi there, I would love to assist you with this task. I already have a tool for finding email addresses. I am available to start working with you immediately. 100% satisfaction guaranteed I'm here to work and help wit Plus
Dear Hiring Manager, Thanks, you for posting your jobs. I have 7 years experience in MS Excel and I have performed all of the duties listed in your job description that I assured. My data entry skills and typing speed Plus