Ολοκληρωμένο

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.

Ικανότητες: Επεξεργασία Δεδομένων, Excel, Αρχιτεκτονική Λογισμικού, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: 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

Σχετικά με τον Εργοδότη:
( 1 αξιολόγηση ) Indianapolis, United States

Ταυτότητα Εργασίας: #17112654

Ανατέθηκε στον:

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 Περισσότερα

$250 USD σε 3 μέρες
(53 Αξιολογήσεις)
6.5

36 freelancers κάνουν προσφορές κατά μέσο όρο $161 για αυτή τη δουλειά

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 ( Περισσότερα

$222 USD σε 3 μέρες
(604 Αξιολογήσεις)
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 Περισσότερα

$250 USD σε 3 μέρες
(274 Αξιολογήσεις)
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 Περισσότερα

$155 USD σε 1 μέρα
(81 Αξιολογήσεις)
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 Περισσότερα

$150 USD σε 7 μέρες
(166 Αξιολογήσεις)
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 Περισσότερα

$250 USD σε 3 μέρες
(70 Αξιολογήσεις)
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 Περισσότερα

$155 USD σε 3 μέρες
(66 Αξιολογήσεις)
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] Περισσότερα

$125 USD σε 3 μέρες
(58 Αξιολογήσεις)
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 Περισσότερα

$250 USD σε 15 μέρες
(7 Αξιολογήσεις)
5.5
$111 USD σε 3 μέρες
(71 Αξιολογήσεις)
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 σε 5 μέρες
(20 Αξιολογήσεις)
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 Περισσότερα

$138 USD σε 5 μέρες
(29 Αξιολογήσεις)
4.7
$277 USD σε 3 μέρες
(4 Αξιολογήσεις)
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 Περισσότερα

$100 USD σε 3 μέρες
(40 Αξιολογήσεις)
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 Περισσότερα

$155 USD σε 3 μέρες
(31 Αξιολογήσεις)
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 σε 3 μέρες
(23 Αξιολογήσεις)
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 σε 3 μέρες
(10 Αξιολογήσεις)
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 Περισσότερα

$150 USD σε 1 μέρα
(28 Αξιολογήσεις)
4.3
$100 USD σε 3 μέρες
(35 Αξιολογήσεις)
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 σε 3 μέρες
(9 Αξιολογήσεις)
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: Περισσότερα

$75 USD σε 1 μέρα
(9 Αξιολογήσεις)
3.6