Completado

Excel Macro VBA Project

I need a script that can be used to help us clean up .csv reports that we run periodically. The columns in the report will all always be in every report, but some reports may have additional columns. However those additional columns in others reports would not need to be referenced in any of the macro’s for cleanup reasons.

Delete duplicate rows where column ‘Donor_ID’ is identical to another donor ID in that same column

Delete duplicate rows where column ‘Email’ is identical to another email address in that column. Do not combine the ones that are blank for this reason only.

If there is a date in the ‘decdt’ field then delete the record entirely from the spreadsheet.

If the field ‘NOMAIL_REASON_DESCR’ contains anything but a blank, or ‘anonymous donor’ then delete it.

Prompt the user of the program to ask if they want to delete records where ‘school’ or ‘church’ is found in the last name field. If prompted with yes then delete the records, if not then leave in the report.

Prompt the user of the program if they want to delete matching gift records. If they choose yes delete any records where ‘MGP’ is found in the ‘flags’ column.

If ‘COTA’ or ‘Event Proceeds’ or ‘fundraising proceeds’ (not an exact match but even if part of that phrase) is found in the last name field of any record then have the user of the program review each and choose if they want to delete it.

Prompt user of program to review any two or more records where columns ‘Address’ and ‘City’ and ‘State’ is identical to another address and city and state in each corresponding column for each record. Do not combine the ones that are blank for this reason only. If we can code this to allow a combine of the two or more records that are found by selecting which to keep and which to delete that would be great but is not a must have. Or, if we could also add an option to ‘skip’ or manually edit the record that would be great for records where it’s an obvious husband and wife who have made separate gifts under just their or their combined names but on different occasions and the address are just a little different.

If you have a good way to code the script or macro where it has the ability to find similar/possible matches in the ‘address’ column where there is not an exact duplicate, but where there is another record in that same column that is similar. We would need to specify a criteria that wouldn’t flag too many of the records to review, but maybe if at least 75% of the characters were a match to another by comparing the first few or last part of the field characters that may work.

Habilidades: Procesamiento de datos, Excel, Arquitectura de software, Visual Basic, Visual Basic para aplicaciones

Ver más: example excel macro vba invoicexls forum, excel macro protect project, excel macro vba select copy paste internet explorer, run vba code in excel, vba project password recovery macro, vba project password remover online, excel vba projects for practice, excel vba password remover xlsm, xlsxwriter macro, how to write macro in xlsx, macros in excel, data processing, software architecture, excel, visual basic, microsoft office, visual basic for apps, microsoft excel, excel macro vba functions cut paste, excel macro vba odbc querytable

Información del empleador:
( 1 comentario ) Indianapolis, United States

Nº del proyecto: #17112654

Adjudicado a:

dgled

Hi, I have experience in managing donations and I even built a Donation Management and Reporting module in excel for one institute. So maybe it can help to understand your needs better. I am a financial expert and a Más

$250 USD en 3 días
(53 comentarios)
6.5

36 freelancers están ofertando el promedio de $161 para este trabajo

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Más

$222 USD en 3 días
(604 comentarios)
8.3
schoudhary1553

Hello, I can help with you in your project Excel Macro VBA Project. I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. We have worked on sev Más

$250 USD en 3 días
(274 comentarios)
7.5
zekovicm

Hi there,I am Miljan,VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agre Más

$155 USD en 1 día
(81 comentarios)
6.7
dpune

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Please look at the feedback left by my em Más

$150 USD en 7 días
(166 comentarios)
6.5
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfe Más

$250 USD en 3 días
(70 comentarios)
6.0
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Más

$155 USD en 3 días
(66 comentarios)
5.6
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. [login to view URL] Más

$125 USD en 3 días
(58 comentarios)
5.6
girofreelancer

I'm a senior software developer with more than 20 years of experience (look at my portfolio for some application developed by me), therefore I'm able to develop every type of application, via code or using Microsoft Of Más

$250 USD en 15 días
(7 comentarios)
5.5
$111 USD en 3 días
(71 comentarios)
5.7
AlexandrUKR

i can provide first draft (in access or excel) for your test within 2-3 days, please clarify possible next steps

$250 USD en 5 días
(20 comentarios)
5.1
TechnoGuruu

Hi, I have 10+ years of experience in Excel, functions, formulas, data processing and macros etc. I have finished many such projects. As you want to create one macro which will filter out the data from CSV based on Más

$138 USD en 5 días
(29 comentarios)
4.7
$277 USD en 3 días
(4 comentarios)
4.8
sorinacho88

Hello, I have read and understood the requirements and I'm happy to create a macro for you that will do the required tasks. I have great experience with Excel, I'm communicative, I put a high accent on quality and Más

$100 USD en 3 días
(40 comentarios)
4.9
dvcontact

Hi, After reading your project description about writing script that will be used to clean up csv file and delete duplicated data, I feel like you have me in mind when creating the project. I have all it takes to deli Más

$155 USD en 3 días
(31 comentarios)
5.4
TetyanaS

The examples of my codes you can see in my books. I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$111 USD en 3 días
(23 comentarios)
4.7
maximwang8661

nice to meet you. your project is very interesting to me. If you hire me, I can start working for you right now. I have a good experience in excel and excel vba. thank you for your job posting.

$155 USD en 3 días
(10 comentarios)
4.2
sloker18

I am proficient with excel macro/VBA development, I can write the macro to clean up the csv file as specified in your project, I am available to start your project right away, feel free to message me if you are interes Más

$150 USD en 1 día
(28 comentarios)
4.3
$100 USD en 3 días
(35 comentarios)
4.5
KGeorgy

Hi, Thanks for your job posting. I've read your project description carefully. As a excel vba expert, I can help you with this project. If you have desire to work with me, please respond me to discuss more. Thanks.

$155 USD en 3 días
(9 comentarios)
4.1
cranius

Greetings, You project caught my attention because I have experience in database clean up. I have prototyped your needs in Excel and would like to share the results, please refer to the video demonstration below: Más

$75 USD en 1 día
(9 comentarios)
3.6