I need to automate a database cleaning process in Excel

Închis Postat la acum 3 ani S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

I need to automate a base cleaning process that consists of the following:

Initially you have to delete some columns that I don't need and leave only what I need.

After that I have to separate the entire row into a different file depending on a field in a cell.

For example

I have a base that has:

Name | Phone | Email Favorite color |

And I only need that in my exported sheets at the end this Mail and Favorite Color

On one page, all the people with a favorite color "red" should come with their email (only those two columns, the others should be deleted), in another file, all the people with a favorite color "green" with their email, in another those of the color "blue" ... etc

Excel Visual Basic Procesare date Microsoft Access

ID Proiect: #29363143

Detalii despre proiect

40 propuneri Proiect la distanță Activ acum 2 ani

40 freelanceri plasează o ofertă medie de 20$ pentru proiect

NIKITALILA

Hi there, I have understood the Project I can develop a simple macro for this, it will delete the rows or columns that need deletion and prepare a seperate Excel file within which we can have sheets based on colour. Mai multe

$15 USD în 1 zi
(41 recenzii)
6.3
JohnRikz

Hello I'm an excel professional experienced in these sort of automation. can we discuss your request? John

$35 USD în 3 zile
(162 recenzii)
6.3
ravinderkumar248

Hi there, I can help you with your database cleaning project based on your requirements . I have 7+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, databases, qu Mai multe

$30 USD în 1 zi
(126 recenzii)
6.0
nelumindralal

Hello, I went thru the description Contact me and I will start the task RIGHT NOW I look forward to hearing from you Thanks Regards Thushara

$30 USD în 1 zi
(36 recenzii)
5.2
jiansevillejo

Hi, I'm interested on this post. I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I can help you finish this work as soon as possible.

$18 USD în 1 zi
(73 recenzii)
5.1
mowachira77

Hi there, I am an expert in excel, database programming, Access, VBA and data processing. In this regard, I am going to automate the process of cleaning your data as you have described. I am ready to start working on y Mai multe

$20 USD în 1 zi
(45 recenzii)
4.8
joicyarockiaraj

I have more than 5 years experience in typing & expert in Web designing. Also an Educator & Having good typing speed, knowledge of relevant computer applications, attention to detail and accuracy, written comprehension Mai multe

$10 USD în 3 zile
(11 recenzii)
4.1
chnsci

I can do this project right now with 100% accuracy. I understood your project description. I am an expert in Visual Basic, Data Processing, Excel, Microsoft Access, and interested in your project. I work efficientl Mai multe

$18 USD în 2 zile
(9 recenzii)
2.9
vipin0110

Greeting! My name is Vipin Kumar Garg and I am a software engineer (MCA). I have 20+ Yrs. Exp. in MS Excel VBA (Macro) and MS Access. I have developed around 500 macros & modules for the global sales team, paper mill, Mai multe

$10 USD în 2 zile
(1 părere)
1.9
cocthe111

Hello sir, I read your description and I understand all the requirements and I am experienced in database data extraction also i have been working on similar project before. If you give this job to me I will do my b Mai multe

$20 USD în 1 zi
(1 părere)
0.7
ahmedtryaq

I see you need some help in data cleaning automation. I will be pleased to work with you :) I'm a certified data analyst, I have a nanodegree in advanced data analysis and statistics. I worked on data analysis in pyth Mai multe

$20 USD în 2 zile
(1 părere)
0.6
abhishek009856

I have gone through your project details and I am sure that I will accomplish it. So, I am ready are you. see in you in the inbox to get it done ASAP. your regards Abhishek

$10 USD în 2 zile
(0 recenzii)
0.0
DataBusTB1001

Hello! Sir, I can understand your work. I am professional and very efficient in data entry working. I can complete your task within the timeframe. Customer services are my first priority. My primary goal is to satisf Mai multe

$10 USD în 1 zi
(0 recenzii)
0.0
alishalimbu903

Hello! I have been using Excel since my university projects. So I believe that I can Handel your project effectively.

$20 USD în 7 zile
(0 recenzii)
0.0
Noorariffah

Greeting Sir, Hi ,My name is Noor Ariffah Chung Abdullah. I know excel ,word and different types of skills of typing and data entries. I can do all types of work in excel. Hence, I can say that I am data entry expert Mai multe

$17 USD în 3 zile
(0 recenzii)
0.0
Ben123Ben123

Hi Thank you for your project description I love to work with you. I have understood what you want and how to deliver quality work to you Thank you sincerely Bibek tamang https://www.freelancer.com/u/Ben123Ben123 Mai multe

$15 USD în 1 zi
(0 recenzii)
0.0
pateljaimin220

Hi, This is Jaimin Patel. I have earned Diploma in Information technology . I have done such work in past. So, I am able to do such work in time frame.

$15 USD în 1 zi
(0 recenzii)
0.0
hr4981

Hello sir I am interesting for the job. I am computer operator. I have expert team. I have 4 years experience.

$20 USD în 4 zile
(0 recenzii)
0.0
vijendrales1981

Hi, I read your project details and want to work for you. I can easily do your job. If you want hire me then please accept my proposal. Thank you, vijendra singh

$18 USD în 7 zile
(1 părere)
0.0
Habib5353

Hello sir I am interesting for the job. I am computer operator. I have expert team. I have 4 years experience.

$20 USD în 3 zile
(0 recenzii)
0.0