Closed

Hire an Excel Expert

Uploaded sample files.

Interested bidders can download them here: [login to view URL]

Looking for someone with good excel skills.

We get pricelists from our suppliers (mostly in Excel) from which we need some basic fields/cloums to upload to our webshop.

The upload file needs to be Excel as well.

The trouble is that each supplier has his own way of doing things, leaving us with a lot of work to get the information we need.

Some of them have good pricelists with almost all colums we need, others have only 3 or 4 coloums we need.

We now want to have an Excel Macro, which should do the following:

1) read the file(s) we select (from 1 supplier at the time)

2) controll if the files is/are still correct

3) export the fields we need from the pricelist to the corresponding colums in the output file

4) save the exported file

This should be relatively easy (at present we copy and paste), but what makes it mistake prone is that

-not all suppliers fields have the same name as our fields

-sometines more than 1 supplier columns need to be moved to just 1 output colums

-alls supplier pricelists are different

We now want uniform spreasheet files for all our suppliers, sothat we can have these completed by a VA (the missing info needs to come from the net and be manually added to the correct colomns.

.

ADDED

PLEASE READ

Getting a lot of responses. However hardly any questions.

If you're serious about ypur bid, then let us know in your own words what you intend to do for your bid. How do yuo intend to make this macro? Just to be clear: we want this process automated in an Excel macro and not someone that will do it manually like we did up to now.

Also we want a macro that can handle all our pricelists from different suppliers.

We will choose someone that will present us a clearly described solution, so stop sending in bids stating only that you can do it, wihout mentioning what exactly you mean by it.

Thanks!

Skills: Excel, Microsoft Access, PHP, Website Design

See more: how to hire excel expert, hire excel expert tel aviv, hire excel expert for 2 hours, excel expert for hire melbourne, excel expert for hire las vegas, excel expert for hire in delhi, excel expert for hire, where can i hire excel expert, looking for excel expert in gastonia, i want to hire an excel expert in the leesburg va area, hire excel expert, Hire an excel expert, excel expert sg hire, excel expert services for hire, excel expert on hire, excel expert hire, looking excel expert create multiple macros

About the Employer:
( 0 reviews ) Netherlands

Project ID: #15040878

54 freelancers are bidding on average €156 for this job

€210 EUR in 3 days
(631 Reviews)
8.3
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex More

€180 EUR in 3 days
(294 Reviews)
7.6
asin1987

Respected Sir/Mam I will do any formula, function, formatting, calculation, modification, automation on Excel. PFA my previous automation works for reference. I hope to work with you. Thanks!! Relevant Skills and Exp More

€155 EUR in 3 days
(131 Reviews)
7.2
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to work with you. Thanks & Regards Khushi India Relevant Skills and Experience Excel, Microsoft Access Proposed Mile More

€250 EUR in 5 days
(250 Reviews)
7.0
TonmoyRoy111

Dear client Without seeing your files it is hard to explain how i will make the macro. But i put my bid as i can make any complex macro in excel. So being optimistic about the project i put my bid. It will be really h More

€200 EUR in 3 days
(263 Reviews)
6.5
koolsidz

I need to see sample excel files. Such kind of applications follow 2 logic. 1. Fixed File Format 2. Format is not fixed but headers are fixed. 3. Format is not fixed. Headers are not fixed. Fixed formats are e More

€167 EUR in 5 days
(157 Reviews)
6.5
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience Relevant Skills and Experience Next ste More

€155 EUR in 3 days
(181 Reviews)
6.6
aanvikm

Hello Sir, I am an expert Excel and VBA developer and I understood your data collection issue. I believe I can help you with this project. Thanks Aanvik Relevant Skills and Experience Excel, VBA Proposed Milestones More

€277 EUR in 3 days
(54 Reviews)
6.7
ksriniravi

I have worked on similar requirement before & as I see it, one converter would be required for each input file format(it is potentially possible that 2 or more suppliers provide input in same format). Relevant Skills More

€180 EUR in 7 days
(159 Reviews)
6.6
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. Relevant Skills and Experience I have already done 100 More

€90 EUR in 3 days
(162 Reviews)
6.5
chriskerpini

The program will work in 2 ways: 1. It will read the selected input file, then open a form with all its column headings listed, allowing you to "map" each heading to the right one in the Output file. 2. It will allow More

€200 EUR in 3 days
(76 Reviews)
6.6
VladimirLilenko

OK. I will try to describe your project: Some columns in the files may be missing. The executor of the project, all files must be saved in a single view.

€150 EUR in 3 days
(105 Reviews)
6.1
zu02

Hi, I'll code all specifications for your pricelist via Excel/vba/ Relevant Skills and Experience vba, Excel, sql, ado Proposed Milestones €155 EUR - default

€155 EUR in 3 days
(52 Reviews)
6.2
alaeddindhahri

Hi, I'm an expert Excel, Access and VBA developer. I have read your description and I'd like to suggest making an access file where you can import data from all suppliers then get it exported to excel Relevant Skills More

€100 EUR in 3 days
(67 Reviews)
5.7
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. I wish to see few spreadsheets with few rows as examples to pl More

€30 EUR in 1 day
(98 Reviews)
5.9
aubrey03

I am the right person for this job, my specialization is process automation. Relevant Skills and Experience The best approach for this project is to define the price list pattern of each supplier and then create macro More

€111 EUR in 3 days
(52 Reviews)
5.1
furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience working on excel. I never miss work and always deliver on time. Relevant Skills and Experience My personal qualities are: - Detail Oriented More

€250 EUR in 1 day
(19 Reviews)
5.1
rakshitdadhich

. Relevant Skills and Experience . Proposed Milestones €55 EUR - .

€55 EUR in 3 days
(19 Reviews)
5.0
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

€111 EUR in 3 days
(26 Reviews)
4.7
supergana

We need to first identify the various patterns of individual suppliers and create one treatment for each pattern. For long run we need to define a template that suppliers can fill (excel/access/web). Relevant Skills a More

€133 EUR in 3 days
(23 Reviews)
4.5