Kapalı

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.

Beceriler: Veri Girişi, Veri İşleme, Veri Tabanı Yönetimi, Excel, Microsoft Access

Daha fazlasını gör: php script import excel files, import excel files quickbooks vb net code, import excel files great plains dynamics, 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, import excel files quickbooks invoicing, excel macro import project files, codeigniter import excel files, import excel files quickbooks, php import excel files, excel files import output php

İşveren Hakkında:
( 2 değerlendirme ) Dade City, United States

Proje NO: #16232312

Bu iş için 44 freelancer ortalamada $45 teklif veriyor

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(299 Değerlendirme)
7.9
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(193 Değerlendirme)
7.3
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(373 Değerlendirme)
7.3
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde49%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(150 Değerlendirme)
7.1
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(227 Değerlendirme)
6.9
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

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(184 Değerlendirme)
6.7
in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)
5.9
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(41 Değerlendirme)
5.8
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.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)
5.6
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(117 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)
5.2
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(56 Değerlendirme)
5.1
in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)
5.0
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!

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
4.5
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(52 Değerlendirme)
4.8
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

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
4.2
laurajiannaras

Hello and welcome to Freelancer, My expertise is with Microsoft Excel and I am greatly familiar with the use of complex functions and macros that minimize manual tasks such as the project you have presented. Since y Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.7
brobb07

1. Excel expert with extensive vba programming experience. I can programatically get the data column ("PLAT") from one sheet to another for you. 2. I have worked for several years in excel and perform daily work Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.8
humayoonsheikh4u

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.1