Excel coding

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

I want to scan some books in order to preserve them for the future. The Excel sheet contains a lot of books, one copy per row.

The column Barcode identifies the individual copy. The different titles is separated by the column MMS id.

This is what I want to be done:

1)

When all the copies of a single title has the status "None" in the column "Process Type", duplicates should be removed. The result should leave me with one row per title (which copy that is left is not important).

2)

When one or more copy of a single title has another status than "None" in the column "Process Type", all rows of this title should be removed.

We need to do this job for a lot of Excel sheets now and in the future, so the solution must work for more than this single Excel file.

Excel Data Processing Data Entry Visual Basic

Project ID: #25750879

About the project

6 proposals Remote project Active 3 years ago

Awarded to:

khushh07

4. Hello Greetings to you!! I am an excel(Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. P More

$30 USD in 1 day
(303 Reviews)
7.2

6 freelancers are bidding on average $20 for this job

rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More

$14 USD in 1 day
(28 Reviews)
5.0
KPCorp2009

We will track and make your plan appear on time. As an agency, Kim Phong corp tries to find the derserved worker to your company project. Ensuring the time management and help you find another solution when there is tr More

$15 USD in 7 days
(0 Reviews)
0.0
deepa13kalki

I can complete the project on time with full accuracy provided an opportunity. Awaiting your response

$23 USD in 1 day
(0 Reviews)
0.0
deysatabdi3

DEAR SIR I AM INTERESTED TO DO THIS PROJECT AND I WILL SUMMIT ON GIVEN TIME GIVE ME ONE CHANCE TO SHOW MINE BEST

$15 USD in 3 days
(0 Reviews)
0.0