Find Jobs
Hire Freelancers

Match, Delete and Export - Excel 365 Macro

$30-250 USD

Slutfört
Publicerad tio månader sedan

$30-250 USD

Betalning vid leverans
I need a macro for Excel 365 that will allow me to export specific columns of data to a new CSV file. The exported file must be in CSV tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. Ideal skills for this job include experience with Excel macros and proficiency in VBA. Match, Delete and Export Excel 365 Macro This project is based on the enclosed sample active workbook, which has the following worksheets (one in each tab, labeled: Cases, Casework, Comments, Contacts, plan_request The macro should run in Excel 365. The macro should basically delete all the entries from a specific “Issuer State” (eg: HI “Hawaii”) from all the worksheets within the workbook. As a reference to crossmatch that entry, the common column is called “Case ID”. Once deleted, export each worksheet to “.csv” text file using their same worksheet names: “[login to view URL]”, “[login to view URL]”, “[login to view URL]”, “[login to view URL]” and “[login to view URL]”. These exported files should have the same information, but without the “HI” entries. In summary: For each entry where “Issuer State = “HI”, in worksheet “Cases”, delete every row in the “Casework”, “Contacts”, “plan_request” and “Cases” worksheets, where the “Case ID” = “HI”. The Macro should perform the following 2 steps: Step A: Delete all the “HI” related rows in all the worksheets based on the "Issuer State" column. 1) Traverse the “Cases” worksheet within the active workbook, and based on the column that contains “Issuer State”, identify the rows where the “Issuer State” is equal to “HI” (Hawaii). 2) For each of those matches, the macro will look into “Casework”, “Contact”, and “plan_request” spreadsheets within that same active workbook, and delete the entire row from those other worksheets, where the “Case ID” cell from the “Case ID” column matches in all the other worksheets. 3) That same row should also be deleted from the original “Cases” worksheet. Step B: Export worksheets into tab delimited text files: 4) Once deleted, export each worksheet to “.csv” text file using their same worksheet names: “[login to view URL]”, “[login to view URL]”, “[login to view URL]”, “[login to view URL]” and “[login to view URL]” in tab separated values. The end result is that these These exported files should have the same information, but without the “HI” entries (belonging to Hawaii". Below is a Sample workbook, before the macro is run, and also the sample of what it should look once the cleanup and export completes.
Project ID: 36687442

Om projektet

53 anbud
Distansprojekt
Senaste aktivitet tio månader sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
$0 USD Om 1 dag
5,0 (305 omdömen)
7,9
7,9
53 frilansar lägger i genomsnitt anbud på $347 USD för detta uppdrag
Använd avatar
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 looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD Om 5 dagar
4,9 (596 omdömen)
8,5
8,5
Använd avatar
Hello, My name is Akriti and I am an experienced Excel VBA programmer with more than 5 years of experience. I have the necessary skills and expertise to complete your project for you. Specifically, I have expertise in creating outstanding logos, letterheads, business cards, posters, flyers and brochures as well as audio editing. I understand that you require a macro for Excel 365 that will allow me to export specific columns of data to a new CSV file in tab delimited format. The criteria for selecting the data to export will be based on specific columns. Additionally, I need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. I believe that I am the perfect fit for this project because of my extensive experience in Excel macros and proficiency in VBA. This combination makes me ideally suited to speed up the workflow while maintaining accuracy. Please feel free to contact me if you'd like further information or would like me to start work on your project right away!
$100 USD Om 1 dag
4,9 (394 omdömen)
7,5
7,5
Använd avatar
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL MACRO EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 300+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$140 USD Om 1 dag
4,9 (268 omdömen)
7,3
7,3
Använd avatar
Yo! I am an expert VBA coder with skills including Excel, Visual Basic for Apps, Data Processing, Data Entry and Visual Basic. I am Database/VBA/SQL Developer Master of Computer Science with 25+ years experience. Database Development: Backend & Frontend, SQL, query profiling, VBA. MS Access, SQL Server, MySQL, PostgreSQL. Developing and supporting DB for Finance/Accountancy, DM, CRM, ERP, ETL etc. MS Office automation: Access/Exce/Word/Outlook. Macros, VBA, API integration. Google Docs automation. System administration tools for Linux using bash, ruby. Data syncing, encryption, automation. The key focus is to deliver time-saving, user friendly and easy to use applications. Please send a message to discuss more about this project. Thank you
$150 USD Om 4 dagar
4,9 (87 omdömen)
6,4
6,4
Använd avatar
Hello, I am an Excel and VBA/Macro expert. I thoroughly read the project details and attached Word document and also checked the enclosed 'Sample Before' and 'Sample After' workbooks. I offer my services to create Match, Delete and Export Macro. I also use Excel 365. Further, I have noted the 2 steps and the sub-steps. I have completed many Excel VBA / Macro / Automation projects with 5 star ratings and excellent reviews. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
$90 USD Om 1 dag
5,0 (103 omdömen)
6,2
6,2
Använd avatar
Hello vw6784323vw, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill set with sophisticated experience in Data Processing and Excel. As a next step I would like to discuss some further questions with you. Either over the chat or a call, whatever you prefer. For my references and qualifications: I graduated in Computer Science with highest grades from one of the most reputable universities in Germany. Currently, I am enrolled in the Master's program. During my studies, I already published a paper on the subject of Artificial Intelligence. Further, I managed to get a lot of hands-on experience by working in several companies that operate in the field of Computer Science. As a native German speaker who was living in Canada for a year, my level in English is proficient/fluent. Further, I am in the preferred Freelancer program, making me part of the top 3% on the platform. Many successful past projects can be seen on my profile page. I am looking forward to working with you and if you have any further questions I would be happy to answer them. Best regards, Simon
$200 USD Om 3 dagar
5,0 (22 omdömen)
5,9
5,9
Använd avatar
Hi, I can develop Excel VBA Macro to export specific columns of data in csv according to given criteria as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
$120 USD Om 3 dagar
4,8 (153 omdömen)
6,2
6,2
Använd avatar
Hello sir/ madam I checked your project description. I can do Microsoft Excel VBA task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saaniya.
$30 USD Om 1 dag
4,8 (180 omdömen)
5,7
5,7
Använd avatar
Senior excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$140 USD Om 2 dagar
4,8 (165 omdömen)
5,8
5,8
Använd avatar
Hello, I'm fullstack expert, with over 13 years experience dealing with web, I can help export to csv file by excel macro. I've previously worked on the exact similar project for American Rudy employer. When do you need this finished by? I understand how annoying it is, and can finish this project for you quickly! Please send me message, so i can understand details for your project. Waiting for your reply. Best regards. Carina
$140 USD Om 7 dagar
5,0 (8 omdömen)
5,1
5,1
Använd avatar
Dear Hiring Manager, I have done similar work earlier for my many client's with 100% satisfaction, INBOX ME FOR DETAILS, I can start your project right now with 100% accuracy and within time deadlines. I am happy to provide you a sample work. Please let me know. Thank you.
$30 USD Om 1 dag
4,9 (43 omdömen)
4,8
4,8
Använd avatar
I am confident that my skillset, experience and background make me the best fit for this project. With extensive knowledge in Excel macros, data entry and data analysis I am able to provide the necessary tools to help you automate your workload related to matching, deleting and exporting data from Excel 365. My expertise in project management has allowed me to successfully lead cross-functional teams and deliver complex projects on time and within budget. My strong organizational skills, attention to detail, and ability to communicate effectively with stakeholders have helped me navigate complex projects and ensure successful outcomes. Additionally, my commitment to excellence makes me an asset to any team or organization looking to achieve growth and drive results. I would be delighted if you could consider me for this job opportunity. Please feel free to contact me if you have any questions or would like additional information about me or my skillset. Thank you again for your consideration!
$140 USD Om 7 dagar
4,9 (5 omdömen)
4,5
4,5
Använd avatar
Master qualification ❤Excellent skill in this project & experience Please read my Reviews from below link❤ ❤️ ❤️ ❤️Dear ❤️ ❤️ ❤️ ⚡⚡⚡⚡⚡⚡ ✅ ⭐✅ ⭐✅ ⭐✅ ⭐✅⚡⚡⚡⚡⚡⚡╰┈➤╰┈➤╰┈➤⚠⚠⚠ These are the recent projects solved https://www.freelancer.pk/projects/pcb-layout/Petit-travaille-simple-Electronique https://www.freelancer.pk/projects/video-services/Design-video-36172777 https://www.freelancer.com/projects/statistics/Statistics-29769906/details https://www.freelancer.com/projects/vb-net/Use-simple-dll-net https://www.freelancer.com/projects/excel/conversion-rate-formulas https://www.freelancer.com/projects/excel/need-excel-expert-28639993 www.freelancer.com/projects/pdf/Create-page-pdf-fillable-Form/reviews https://www.freelancer.pk/projects/pcb-layout/Petit-travaille-simple-Electronique https://www.freelancer.pk/projects/video-services/Design-video-36172777 www.freelancer.com/projects/research/Lead-sources/details www.freelancer.com/projects/business-plans/Design-company-profile-english-arabic/reviews ✅ ⭐✅ ⭐✅ ⭐✅ ⭐✅⚡⚡⚡⚡⚡⚡╰┈➤╰┈➤╰┈➤ I have been working here since the 2020(الحمد لله) ,Thanks for posting and sharing your project.I have experience in this work ,let be handle this task to me ,i am willing to start Now Just contact/Text☎ Why you Choose me On time⚡⚡⚡⚡⚡⚡ On Desire On Solution Thanks⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ Muzammal Hussain
$240 USD Om 1 dag
3,7 (22 omdömen)
5,5
5,5
Använd avatar
Hello, my name is Basanta and I am a native of Odisha, India. I have over 10+ years of experience in different domains such as MNCs such as IBM, Accenture, Amazon and Google. With my extensive knowledge and skills in Data Entry, Data Processing, Excel, Visual Basic and other related software, I am confident that I can provide you with the best possible solution for your project. I understand that you need a macro for Excel 365 that will allow you to export specific columns of data to a new CSV file in tab delimited format. The criteria for selecting the data to be exported will be based on specific columns while matching rows in the other 4 sheets before deleting certain rows based on criteria before exporting. I believe that my skillset makes me the perfect fit for this project - especially my proficiency in Excel macros and ability to work within VBA. Please feel free to reach out if you have any questions or would like me to provide any additional information or clarification regarding this project..
$30 USD Om 1 dag
5,0 (45 omdömen)
4,0
4,0
Använd avatar
Hello! I am the right person to help you complete this project. I am a professional|expert in Visual Basic, Visual Basic for Apps, Data Processing, Excel and Data Entry. My years of experience dealing with related projects to yours have given me the chance to have solid knowledge in this field. You will get exactly what you're looking for by hiring me. If this feels interesting, please message me for further discussion. Sincerely Carolyne
$155 USD Om 2 dagar
5,0 (2 omdömen)
4,1
4,1
Använd avatar
I understand that you need a macro for Excel 365 that will allow you to export specific columns of data to a new CSV file in tab delimited format. The criteria for selecting the data to export will be based on specific columns. I am confident that my skillset makes me the ideal candidate for this job. I have extensive experience in creating dynamic dashboards using Excel, specifically in the area of advanced formulas and pivot tables. Additionally, I am proficient in conditional formatting, forecasting and power pivot analysis. Additionally, I have experience using user forms in email automation via macros as well as data entry and processing of Excel files. I believe my skillset makes me the ideal candidate for this job and would be delighted if given the opportunity to work on it for you. Please don't hesitate to contact me if you have any questions or would like more information about me or my skillset.
$100 USD Om 1 dag
5,0 (9 omdömen)
3,6
3,6
Använd avatar
Hey! I have vast experience in Visual Basic for Apps, Data Processing, Data Entry, Excel and Visual Basic, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing position, and I am happy to work on a freelance basis if that is what you prefer. I look forward to hearing from you soon! Thank you for your time. Thanks - Wilfred
$155 USD Om 1 dag
5,0 (2 omdömen)
2,9
2,9
Använd avatar
Hi there! My name is Akibul and I'm a data entry expert with extensive experience in Excel and Visual Basic. I understand that you need a macro for Excel 365 that will allow you to export specific columns of data to a new CSV file in tab delimited format. The criteria for selecting the data to export will be based on specific columns, and my skillset include being able to create macros that perform complicated operations quickly and accurately. I am confident that my skillset will be the best fit for this project - specifically my experience with Excel macros and proficiency in VBA make me an ideal candidate for this task. If you'd like to learn more about me or discuss further how I can help you with your project please don't hesitate to contact me directly!
$11 200 USD Om 1 dag
5,0 (6 omdömen)
2,6
2,6
Använd avatar
I understand that you need a macro for Excel 365 that will allow you to export specific columns of data to a new CSV file in tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also have experience with macros and proficiency in VBA which would be ideal for this job. I believe I am the best fit for this project due to my experience with Excel macros and proficiency in VBA. Additionally, I am confident that my ability to deliver quality results will meet your expectations. Please feel free to reach out if you have any questions or would like more information about me or my services.
$140 USD Om 7 dagar
4,9 (6 omdömen)
2,7
2,7
Använd avatar
Dear sir/ma'am With nearly 14 years of coding experience, I have written scripts to automate repetitive manual tasks in Excel and to consolidate multiple Excel files into one with utmost accuracy and speed. I have created several standalone Excel utilities using Macros/VBA coding with advanced features including print in any customised format, generation of charts & graphs for easy and better analysis of the data. I also have proficiency in VB.NET, VB6, C# programming languages and have developed several desktop apps using the same. I believe I will be able to fulfill all the project requirements along with any extra customisations if required and complete the project within the stipulated time... Thank you
$140 USD Om 7 dagar
5,0 (3 omdömen)
1,6
1,6

Om kunden

Flagga för UNITED STATES
San Diego, United States
5,0
3
Verifierad betalningsmetod
Medlem sedan dec. 17, 2007

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.