Find Jobs
Hire Freelancers

Hire an Excel Expert

€30-250 EUR

Closed
Posted almost 7 years ago

€30-250 EUR

Paid on delivery
Hi I have 18 excel files containing product information and I need to gather all the information in a single file. Some of the information are in several files but some you will only find in one. The unique cell (ID) in every file is PART_NO. A file named "preisliste_10696_alle_gruppen_ORI_HER_ATT_dk" is the "main" file. It contain all articles, with article number (Part-No), Danish and English explanation, prices, weight, manufacturer and original part number and some attributes. These attributes should be further divided into separate columns for length, width and thickness. Any other attribute information can just be left under the original cell. "Artikel_enthealt_alle_gruppen" contains the part number (part-no) in the same manner as "preisliste_10696_alle_gruppen_ORI_HER_ATT_dk". Include number says that given item number also includes the item with the following article number (include number) and how many pieces of article number, hence the quantity. "Artikel_passend_fuer_fabrikat_alle_gruppen_dk" recalls the producer article number to suit. "Artikel_zubehoer_gruppe_01" - "Artikel_zubehoer_gruppe_15" are all products split into 15 different groups with its part number (part-no), suitable accessories, Danish and English explanation. The problem is as mentioned that I need to gather the different information into one excel file with the information split into something like this: PART-NO., DK, EN, CATALOG PRICE, YOUR PRICE, GROUP, WEIGHT KG, MANUFACTURER, ORI. PART-NO, ATTRIBUT, ATTRIBUT Tykkelse, ATTRIBUT Længde, ATTRIBUT Bredde, INCLUDE NUMBER, QUANTITY, Artikel egnet til manuf... ,ACCESSORIES, ATTRIBUT 2. Regards Ørjan
Project ID: 13599773

About the project

64 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
64 freelancers are bidding on average €139 EUR for this job
User Avatar
Bid Summmary Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve.
€250 EUR in 3 days
4.9 (375 reviews)
8.1
8.1
User Avatar
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.
€150 EUR in 3 days
4.9 (440 reviews)
7.8
7.8
User Avatar
We can prepare import file (single file) from all the 18 files. We clearly understand that, All the 18 files having product information in different place example product name in one spreadsheet in Column A and in another in Column C, All product name should be in column A (example). we can merge and place data in place correctly. Looking forward to work in this project. Thanks
€210 EUR in 3 days
4.9 (229 reviews)
7.8
7.8
User Avatar
sure i can consolidate data into one sheet sure i can consolidate data into one sheet sure i can consolidate data into one sheet
€100 EUR in 1 day
4.9 (521 reviews)
7.3
7.3
User Avatar
Greetings Ørjan! I have read your requirements, reviewed the attachments, understand what needs to be done. Once awarded, I can show you a manually created Excel file with desired output for a sample Part No. to ensure that my understanding is correct and then write a macro to completely automate the process. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last few MONTHS , I have spent at least 225 HOURS on automation in Excel every month. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Have a Great Week Ahead! Srinivasan Krishnamoorthi
€120 EUR in 2 days
5.0 (216 reviews)
6.9
6.9
User Avatar
Hi Sir, I will perform accurate data processing and data entries to merge all 18 files into one single file. I will deliver 100% quality results according to your requirements. I will charge only €100 for this project and complete the work by tomorrow night. Please let me know how soon you want me to start the work? Awaiting for your prompt response. Thanks & Regards G.M Sakhiya
€100 EUR in 3 days
4.8 (70 reviews)
7.0
7.0
User Avatar
Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
€150 EUR in 5 days
5.0 (66 reviews)
5.9
5.9
User Avatar
I have been working with Microsoft excel for 16 years, I can do formulas, Vlookups, Picot Tables, Conditional formatting and many other Excel functions. I have taken all classes from 97 to 2010 beginner to expert. I have already started the project . I should have it completed shortly. Message me if you are interested in my results. Donna
€111 EUR in 1 day
4.9 (25 reviews)
6.2
6.2
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the website's API - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
€150 EUR in 3 days
4.8 (81 reviews)
5.8
5.8
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I can start working on the project immediately and complete the job within some hours. I can offer a macro doing the job for the case you need it for repetitive use for an extra €15. Regards
€88 EUR in 0 day
4.9 (64 reviews)
5.7
5.7
User Avatar
- Can get the information of each Part_NO from across the 18 files which holds various information and get them consolidated into one single template. - Have expertise in Excel data consolidation reporting. - Done similar seaching across multiple sheets and consolidating into one. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - University, US - Scoring the answer sheets based on keyword and number of occurences.
€100 EUR in 3 days
4.6 (50 reviews)
6.1
6.1
User Avatar
Hi, Thanks for posting your requirement. I have an extensive knowledge of data processing, visualization and analysis using excel, VBA, macros and other technologies like Power BI. Please check our portfolio for works completed in past. I have understood your requirement and can surely assist you with this development. Let's connect to discuss in detail. Regards, Pranshu Agarwal
€100 EUR in 1 day
4.9 (22 reviews)
5.5
5.5
User Avatar
HII THERE, I AM DATA ENTRY/DATA PROCESSING EXPERT WHO KNOWS THE VALUE OF TIME, VERY HARD WORKING AND ALWAYS DELIVERS THE WORK ON TIME. I PROVIDE PROMPT RESPONSE AND QUICK DELIVERY OF WORK. IF YOU ARE LOOKING FOR DATA ENTRY, I AM THE RIGHT PERSON FOR YOU. AVAILABLE 24-7. A TRUSTED FREELANCER
€200 EUR in 6 days
4.8 (28 reviews)
5.0
5.0
User Avatar
Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel. I'll do all your requirements just on your need. Please see my portfolio here. Now I'm fully free and I can start immediately and working intensively on it. I think in maximum 5 days I'll finish. Also next 1 months I will correct any errors free of charge in my software; i.e. until then as it doesn't become a robust , I will support that software. Thanks for your time and Regards, Zura
€250 EUR in 3 days
4.5 (24 reviews)
5.5
5.5
User Avatar
Hi Ørjan, I am an experienced Finance professional with over 15 years experience using Excel. I am familiar with advanced Excel formulas and can help with your project. I would propose to complete your project by firstly splitting the data in the main file into the correct columns and saving as an Excel spreadsheet. I would then look to set up the other files in the same way and then set up a formula to lookup the part number from the main file and find the data listed in each of the other 18 files. Questions I have for you are: - What version of Excel are you using? - It appears that all of the data in the columns is separated by a semi-colon (;) - but can I please confirm that that is always the case? I welcome the opportunity to discuss your project further and to work with you. Thanks & regards Melanie
€160 EUR in 3 days
5.0 (12 reviews)
4.4
4.4
User Avatar
I am a statistician with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank you.
€94 EUR in 1 day
4.7 (9 reviews)
4.0
4.0
User Avatar
I would like to work on this project. It's true that I'm very new in this site but I'm not new in this fields. I have done as same of many projects. So, I think I can help you on this project. Please refer to inbox for further details. -Regards
€30 EUR in 3 days
5.0 (16 reviews)
3.9
3.9
User Avatar
Dear Orjan I am an excel professional having hands on expertise in data management via consolidation merging etc I will do your project as per your requirement. best regards humayoon
€120 EUR in 1 day
4.7 (12 reviews)
4.2
4.2
User Avatar
Bid Summmary I am a hardworking individual and complete my work timeously and accurately. I pay attention to detail and pride myself on my work. I will combine all the worksheets into one worksheet as requested.
€222 EUR in 5 days
4.8 (4 reviews)
3.4
3.4
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
€150 EUR in 3 days
4.2 (10 reviews)
3.4
3.4

About the client

Flag of NORWAY
Flekkerøy, Norway
5.0
3
Payment method verified
Member since Mar 24, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.