Sedang Disiapkan

Excel Expert Needed (Repost)

I have a 7000+ product csv excel file that contains product info from various(5+) dropshippers. Many of the products have been discontinued and need to be removed from the site. My dropshippers provide current csv excel files. I need to reconcile the information without losing the info in the current csv excel file being used. Project consists of editing the current csv file to edit items no longer available and also creating a second csv file with the items that are not currently on the site and need to be added. Please see attached files as a reference. The 2006 file has the products currently on the site, the 2007 file is the file with currently available items. There is one item in common.. the code. (Note in examples that the code in the 2006 file has three letters in front of it... very easy to remove to reconcile the files and then needs to be added back.) For items no longer available, need to change Orderable to "No" and replace the headline with "Discontinued please make another selection". I am sure this can easily be done quickly with an excel formula. Bid is to do the work and provide me with the formula / teach me how to update. Bid is to reconcile all data files. I have already divided up the main data file into subsections based on dropshipper and downloaded the new dropship files... eliminating products I don't need.

1. Reconcile all data files with current inventory by changing Orderable to "No" and replacing Headline with "Discontinued..."

2. Give me the formula / teach me to reconcile two excel documents with one thing in common (code).

3. Create second file for each dropshipper with products that need to be added.

Will be working with FOUR dropshippers and files. Not all products from dropshippers are on site or will be added... just camping related products.

Please only bid if you can do the work. I am having to repost as previous bidders did not accept the job in a timely manner.

Kemahiran: Pemasukan Data, Pemprosesan Data, Pengurusan Projek, Reka Bentuk Laman Web, XML

Lihat lebih lanjut: reference letters, me excel, letters reference, letters examples, job letters, headline design, formula it, file excel expert, expert excel job, excel expert site, examples reference letters, dropship design, common current, bid job editing, new excel, n excel, job inventory, inventory job, teach create website, xml excel, repost project, headline, expert excel, excel job, excel inventory

Tentang Majikan:
( 14 ulasan ) Oceanside, United States

ID Projek: #116216

Dianugerahkan kepada:

best4best

Hi, I have gone through both the files and read carefully the description. I had previously made a bid for this project, but unfortunately not the winner. I can definitely do this job. It is easy for me. Instead I c Lagi

$30 USD dalam sehari
(100 Ulasan)
5.7

17 pekerja bebas membida secara purata $57 untuk pekerjaan ini

bsoist

Please see PMB for details.

$100 USD dalam 2 hari
(29 Ulasan)
6.1
thesa

Hi sir, I'm an excel expert, I can teach you the formula and I can do the work for you. I can start right now. My bid is only $100.00 for 7 days. I'm detailed oriented. Quality work and accuracy in a timely manner is Lagi

$100 USD dalam 7 hari
(32 Ulasan)
5.3
asaikiran1979

Hi, I can complete ASAP. Pls check PM ASAP. Thanks, Sai Kiran

$35 USD dalam sehari
(55 Ulasan)
5.1
cheungkc

We will be glad to assist please

$50 USD dalam 3 hari
(6 Ulasan)
3.1
phaseonemedia

I can write you a script that will update your list automatically everyday. I can even have it all automated. Ive done it many times before, so long as your dropshippers provide you with live xml or csv feeds.

$50 USD dalam 0 hari
(7 Ulasan)
3.1
omnisite

Please see PMB

$50 USD dalam 3 hari
(4 Ulasan)
2.6
ajay192

I suspect you are having to repost your project several times since the price band selected for this class of project in perhaps not adequate. Please see PMB for details of our proposal. Ajay

$56 USD dalam sehari
(1 Ulasan)
2.5
anupamsinghi

Hi, I am very keen to do your project. I have understood your project and I would be able to provide you required data. I will also provide you step by step process and formula to reconcilation of spreadsheet. looki Lagi

$50 USD dalam 2 hari
(1 Ulasan)
1.8
Alamo2000

Could definitely do this

$40 USD dalam 3 hari
(0 Ulasan)
0.0
hundredrabh

Hi, real simple. can be done. regards

$30 USD dalam 2 hari
(0 Ulasan)
0.0
ramvinod

we can do this assignment

$50 USD dalam 5 hari
(0 Ulasan)
0.0
prakashpatodia

Pls see PM

$100 USD dalam 4 hari
(0 Ulasan)
0.0
anuramn

I can accomplish the task that you have asked for. I've good work experience and knowledge in MS Excel.

$60 USD dalam 4 hari
(0 Ulasan)
0.0
sunil2007

Get it done [url removed, login to view] let me know if you are intrested. Thanks.

$40 USD dalam 10 hari
(0 Ulasan)
1.4
dhawalupadhye

i able to do the work in four days i am expert to do this work before and i had an idea to this work bysimplest way if you are intersted .i do the job....

$50 USD dalam 4 hari
(0 Ulasan)
0.0
lakshmaiahv1108

Hi, I can do this job. Thanks Lakshmaiah

$80 USD dalam 7 hari
(0 Ulasan)
0.0