Hire an Excel Expert

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

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!

Excel Microsoft Access PHP Website Design

Project ID: #15040878

About the project

53 proposals Remote project Active 6 years ago

53 freelancers are bidding on average €156 for this job

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
(335 Reviews)
7.9
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
(183 Reviews)
7.5
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
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
(208 Reviews)
6.8
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.8
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
(182 Reviews)
6.6
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
(177 Reviews)
6.7
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
(308 Reviews)
6.7
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
(77 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
(138 Reviews)
6.3
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
(53 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
(72 Reviews)
5.8
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
(21 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
(97 Reviews)
5.7
rakshitdadhich

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

€55 EUR in 3 days
(19 Reviews)
5.0
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
(24 Reviews)
4.7
nelson1812002

I have over 28 years' as a developer and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, shipping companies, and others. Relevant Skills and Experience These a More

€166 EUR in 7 days
(1 Review)
4.4
Moh6335

I have read your project derails and would like to work on your project Kindly visit the below mentioned link to have a glance at our portfolio https://www.freelancer.com/u/Moh6335.html Thanks Relevant Skills and Ex More

€135 EUR in 4 days
(5 Reviews)
4.2
sobhad20

hi sir, i have gone through your project description and i am very much interested in doing your project. i am sure i'll exceed your expectation. Relevant Skills and Experience Having good typing speed with careful More

€250 EUR in 3 days
(26 Reviews)
3.6
wangyu2016

I am able to understand the project requirement and look forward to an opportunity to work with you. Relevant Skills and Experience master of Microsoft office. Proposed Milestones €150 EUR - 1 €50 EUR - 2 Can you w More

€200 EUR in 3 days
(4 Reviews)
4.8