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

Fixing Excels documents formats

Hi there,

--- PLEASE READ CAREFULLY ---

I have two Excel documents, both are identical in terms of information, however the first document has been amended and many fields have been removed (This one is the master version). The second document has the same information and it is where all the work must be done.

What i need you to do is:

1- Match the SECOND document to the FIRST version and that means, you will need to cross check both documents and make sure whatever info that doesn't exist in the FIRST document to be removed from the second version.

To simplify this: First documents has 2093 row, the second document has 2986. You will need to keep the similar fields that shows in both documents and delete the rest from the second.

2- In the second document you will need to merge the description columns into one column. Basically column C/D/E/F/G/H/I all in one column.

3- In the second document, the products descriptors has been formatted in ABC123. What i need is to reformat it in 123ABC

Please bid if you know how to do it and sure you can achieve it.

Ικανότητες: Επεξεργασία Δεδομένων, Excel

Περισσότερα: too many cell formats macro, xsformatcleaner.xla excel 2016, too many different cell formats won't go away, too many cell formats excel 2010, too many different cell formats excel 2013 fix, excel too many cell formats excel 2010, clean excess cell formatting excel 2010, excel excess formatting cleaner add-in 2010, A b c d e f g h i j k l m n o p q r s t u v w x y x.......a , hi, we are designing a new product similar to www.kallpod.com and thewaiterbutton.com, Hi, I am Erp Project manager and C# .NET Framework Developer currently employed in one of the biggest software development comp, Hi! This project is a series of interviews. Each is an hour long (approx). I\ d like to get an accurate transcription of the int, Hi Guys, I need a square banner for promotion in facebook and instagram, The banner has to have a very good fonts, please be c, Bug fixing C++, url d une application web http 10.5 89.158 index php dir c

Σχετικά με τον Εργοδότη:
( 17 αξιολογήσεις ) Dubai, United Arab Emirates

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

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

Khurramz

Hi I can compare and update second sheet using formulas and achieve the target quickly and accurately. Thanks

$30 USD σε 1 μέρα
(314 Αξιολογήσεις)
7.3

87 freelancers are bidding on average $24 for this job

best4best

Hi, I am an Excel expert. Please share both the files, I can match and format the data as required. Regards

$20 USD σε 1 μέρα
(140 Αξιολογήσεις)
6.4
TonmoyRoy111

Dear client I have previously carried out a number of projects in excel using macros and formulas. I can certainly help you in this project. Kindly contact me for further details. Roy

$30 USD σε 1 μέρα
(249 Αξιολογήσεις)
6.4
nadeeemsarwar

HELLO SIR! If you are reading my proposal then I'm assuming you are considering me for your next project so this is my one chance to impress you and tell you why you should pick me over anyone else. I specialize in D Περισσότερα

$20 USD σε 10 μέρες
(20 Αξιολογήσεις)
5.2
abdolah2014

HI I am an excel-vba Expert and I can finish your project in 2 hours start the chat to finish it up ...........................................................................................................

$25 USD σε 10 μέρες
(37 Αξιολογήσεις)
5.3
nwss1986

[url removed, login to view] you send me the two excel files? I will start now and deliver in an hour or [url removed, login to view] see my previous works and reviews in this site; it will help you know my proficiency in excel. Thank you.

$20 USD σε 0 μέρες
(54 Αξιολογήσεις)
4.9
Ranitani9

Hello I have an experienced team they have done many projects of excel like yours. Quality, accuracy, good low rates and timely delivery is guaranteed. For further discussion please msg me. Regards Tanzeela.S

$20 USD σε 1 μέρα
(23 Αξιολογήσεις)
4.5
aubrey03

A proposal has not yet been provided

$20 USD σε 1 μέρα
(21 Αξιολογήσεις)
4.9
$25 USD σε 10 μέρες
(17 Αξιολογήσεις)
4.4
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do Περισσότερα

$20 USD σε 2 μέρες
(29 Αξιολογήσεις)
4.3
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Περισσότερα

$50 USD σε 2 μέρες
(15 Αξιολογήσεις)
4.1
ongskjason

A proposal has not yet been provided

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

Hi, I am expertise in excel coder & formulas, very interesting to your project & placed bid for your consideration. I am available, ready to work now to provide best result for your project. Appreciate If you Περισσότερα

$20 USD σε 1 μέρα
(15 Αξιολογήσεις)
3.5
RenPerera

A proposal has not yet been provided

$20 USD σε 1 μέρα
(6 Αξιολογήσεις)
3.2
Pmshah1985

I am Chartered Accountant by profession having experience of more than 6 years in a reputed MNC, worked as financial analyst .Proficient in accounting, bookkeeping. Very hardworking and good communication skills Servi Περισσότερα

$20 USD σε 1 μέρα
(10 Αξιολογήσεις)
3.4
$25 USD σε 10 μέρες
(8 Αξιολογήσεις)
2.9
Erusha

Hi there, I've read the project description and understood the work well. I can format the excel sheet effectively and provide you the similar document of an existing one. I'm interested to work on this project and Περισσότερα

$20 USD σε 1 μέρα
(7 Αξιολογήσεις)
3.0
prasannjeetp

My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.

$20 USD σε 1 μέρα
(10 Αξιολογήσεις)
3.3
sagarsureja3

I have gone through the requirements and can complete it as soon as possible

$20 USD σε 2 μέρες
(4 Αξιολογήσεις)
2.9
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can d Περισσότερα

$20 USD σε 0 μέρες
(6 Αξιολογήσεις)
2.4
jawadrafia

Hi there: Being an expert in Excel, i am offering my services. I am university qualified professional having 10 years working experience in Excel. You will be amazed to see my professional services and i assure y Περισσότερα

$20 USD σε 2 μέρες
(3 Αξιολογήσεις)
2.5