Ditutup

Prepare excel files for import

I'm the national sales manager for my company, but I constantly get stuck behind my desk doing administrative activities. I would like to start outsourcing some of those activities.

I consistently have little Excel/Access projects with which I need help. I've never used a service like this before though, and I would like to see how well it works before sending the additional/larger projects.

I have two Excel files attached. One is a master file provided by a manufacturer (2018-opw-us-price-list_MULTIPLIERS). It has 6,830 records.

The second file (OPW4IMPORT-020518) has 700 records that were dropped out of two internal database systems. (The systems are identified in the "PKG" Column.) Because they were dropped out of two separate systems, most of the records have duplicate Item #'s.

I need the prices listed in column "E" (PLAT) of the master file copied to column "E" (2018) to the corresponding records on the file so that we can import the information back into our two systems. We simply need to get the "PLAT" prices from the manufacturer for import into our systems.

Kemahiran: Pemasukan Data, Pemprosesan Data, Pentadbiran Pangkalan Data, Excel, Microsoft Access

Lihat lagi: php script import excel files, import excel files quickbooks vb net code, import excel files great plains dynamics, how to import data into excel from web, transfer data from one excel worksheet to another automatically, import data from excel to matlab, how to import data to excel, import data into excel from another excel file, excel import data from text file, quickbase import from csv, quickbase api, data entry, data processing, excel, import data closed excel files vba, import export excel files magento, import excel files quickbooks pro 2008, import data excel multiple excel files worksheet, import excel files mysql php, import excel files microsoft dynamics

Tentang Majikan:
( 2 ulasan ) Dade City, United States

ID Projek: #16232312

43 pekerja bebas membida secara purata $46 untuk pekerjaan ini

FINGERRPRINT

Hi there, we can get the required information for import file from the manufacturer source file. we can get you the excel file as your requirement. Thank you

$54 USD dalam sehari
(324 Ulasan)
8.0
Kalpanasekhar

Dear Client, We can get every product detail copied from a given source on an excel sheet or csv. We are interested in this project. We have done similar projects before, so confident that we would not face any Lagi

$49 USD dalam 10 hari
(176 Ulasan)
7.3
bouslimi1979

Hi, can you please send the 2 files you are talking about ? I ll code a macro to make the match between the 2 files to get the prices. Thanks

$50 USD dalam sehari
(255 Ulasan)
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD dalam sehari
(281 Ulasan)
7.2
ponnarasiBabu

I read and understood your requirements - Prepare excel files for import and shall be able to complete the task listed here and shall be able to take the task as you get. So if you are satisfied with my work, you can Lagi

$50 USD dalam sehari
(400 Ulasan)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$45 USD dalam 0 hari
(210 Ulasan)
6.8
qhairil

Greeting, Thanks for the description and taking time to read my offer First of all, let me summarize my understanding based on the project post : We have to fill in column "E" on (OPW4IMPORT-020518) file with va Lagi

$40 USD dalam sehari
(45 Ulasan)
6.3
$50 USD dalam 10 hari
(60 Ulasan)
6.3
$50 USD dalam 10 hari
(76 Ulasan)
6.1
iasmumbai

Hi, Your excel uploads are missing on the site. I have what it takes to fill the requirements of this job, using my Ms Office VBA programing skills and communication skills, my positive attitude for everyone. I will Lagi

$35 USD dalam sehari
(118 Ulasan)
5.7
sajibdigital

Hi, I pray and hope that you will give me chance to work with you after checking my profile. Lets chat for more details.

$50 USD dalam 2 hari
(71 Ulasan)
5.7
younus15

Hello. I can do your project in less than a day according to your description with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive exp Lagi

$40 USD dalam sehari
(90 Ulasan)
5.5
tiaratechies

Hello, We are a team of certified team of excel experts with lot of experience if you are interested in getting things done by us, drop a message to discuss further on this.

$100 USD dalam sehari
(37 Ulasan)
5.2
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, Lagi

$50 USD dalam sehari
(24 Ulasan)
5.1
katiewells3

I am an Australian business analyst with 15 years professional experience automating Excel and Access with macros / VBA and SQL. I have a creative approach to problem solving, an eye for spotting patterns and a high at Lagi

$45 USD dalam 3 hari
(25 Ulasan)
4.9
kahilH

Hello i see that you have some data procesing in excel sheets in general i can help with that i've done simillar work many times before so i invite you to discuss more on chat about the project Thank you

$35 USD dalam 10 hari
(25 Ulasan)
5.0
Orientwork

I am experienced in the Data entry, Book Writing and Graphic Designer. I also understand your requirement and my aim is to analyze your requirement in logical way and give you perfect solution. I provide expertise serv Lagi

$50 USD dalam 3 hari
(62 Ulasan)
4.9
liviuconcioiu

Hi, I will be glad to help you out. I can automate this thing as I did it a few times here on Freelancer, if you check my Feedback. Thank you!

$35 USD dalam 10 hari
(28 Ulasan)
4.5
clearcutwritings

Hi How are you today? I can help you with your project. I am proficient in excel: -spreadsheet tidy up -data entry & data verification -data analysis within excel, such as, calculations, formulas, tracking and tr Lagi

$35 USD dalam sehari
(12 Ulasan)
4.0
Sholaja

Greetings, I have gone through your project description and I'm very much interested in doing your project. I'm sure I will exceed your expectation. Thank you for your consideration.

$35 USD dalam 10 hari
(20 Ulasan)
4.0