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: “Cases.csv”, “Casework.csv”, “Comments.csv”, “Contacts.csv” and “plan_request.csv”. 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: “Cases.csv”, “Casework.csv”, “Comments.csv”, “Contacts.csv” and “plan_request.csv” 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.

I am looking for a logo designer to create an illustrative logo for my healthcare office. I have a final name, and I'm looking for a logo which clearly reflects the brand I'm looking to create. I'm looking for a logo that stands out in an industry that can be highly competitive, and which can be used across various mediums for promotional purposes. The designer I'm looking for must be creative, experienced and have an eye for detail as well as an understanding of the current health and fitness industry.

I am in need of a Moodle expert to help me complete missing coursework and grades for a private adult training course. Almost all of the coursework and grades are missing and I have a specific deadline of one week to complete them. This is an instance that was recently upgraded from M3 to M4 and moved to a new server. Almost everything is intact. The course module content is intact. Almost all of the students essays and grades are showing as incomplete- even though the student has an entry in the Grade Book.

I am looking for a developer who can help me develop a custom IPTV application, with my brand, with both live TV channels and on-demand video content for the Android platform. The application should also provide support for multiple languages (French and English). To make it more user friendly, I'm looking for features like a channel guide and EPG, as well as recording in background and time-shifting functionalities. I'm open to other suggestions.

I am looking for a skilled Facebook advertising specialist to create and run a campaign aimed at increasing brand awareness among my existing customers. Store details . budget . items . Target area in the link below

Hola ya cuento con un binario, quisiera actualizarlo para que sea compatible con las versiones mas recientes tanto para IOS como par Android