Fixing Excels documents formats

Dokončeno Zveřejněno před 6 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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.

Zpracování dat Excel

Identifikační číslo projektu: #16463740

O projektu

84 nabídek Projekt na dálku Aktivní před 6 lety

Uděleno uživateli:

Khurramz

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

$30 USD za 1 den
(380 recenzí)
7.6

84 Freelnceři na tento projekt zveřejňují nabídky v průměru $24

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 za 1 den
(417 Recenzí)
7.1
best4best

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

$20 USD za 1 den
(162 Recenzí)
6.4
aubrey03

A proposal has not yet been provided

$20 USD za 1 den
(157 Recenzí)
6.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 Další

$20 USD za 2 dní
(82 Recenzí)
5.8
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, Další

$50 USD za 2 dní
(34 Recenzí)
5.8
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 Další

$20 USD za 1 den
(42 Recenzí)
5.6
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 Další

$20 USD za 10 dní
(27 Recenzí)
5.3
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 za 10 dní
(37 Recenzí)
5.3
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 za 1 den
(46 Recenzí)
4.6
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 Další

$20 USD za 1 den
(15 Recenzí)
4.4
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 Další

$20 USD za 1 den
(27 Recenzí)
4.2
ongskjason

A proposal has not yet been provided

$30 USD za 1 den
(7 Recenzí)
3.8
sagarsureja3

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

$20 USD za 2 dní
(5 Recenzí)
3.6
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 Další

$20 USD za 0 dní
(15 Recenzí)
3.7
RenPerera

A proposal has not yet been provided

$20 USD za 1 den
(8 Recenzí)
3.3
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 Další

$20 USD za 2 dní
(3 Recenzí)
2.5
epchocl

I am an intermediate user of excel and very familiar with what you are asking for. It will require the use of Vlookups and Concatenation as well as Match to deliver the outcome that you need. I have done cleanups l Další

$21 USD za 10 dní
(2 Recenzí)
1.6
Inave

Hello, I will be the perfect person for your task. Please note that in order your task to be done accurately the steps needs to be reversed. comparing the 2 files will be done with VBA 100% but the logic of the Další

$25 USD za 2 dní
(1 recenze)
1.6
sandesharma

Hi, thanks for the opportunity. Would you be able to share additional insights related to the project, excel template and any other minute details to keep in mind while accomplishing this work. Thanks and happy to h Další

$20 USD za 10 dní
(1 recenze)
0.6
manbirk251

I am Data Entry/Data Processing Expert (4 years exp.) who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges ... . Další

$25 USD za 2 dní
(1 recenze)
0.0