Find Jobs
Hire Freelancers

Create 2 Excel Automatisms

€30-250 EUR

Ukończony
Opublikowano prawie 7 lat temu

€30-250 EUR

Płatne przy odbiorze
Hello, I´m looking for an expert in Excel who can create two automatisms: 1) to number articles. All articles are listed in Excel files and the article number must contain 3 parts: 1000-01-01. Part one 1000 is the article name, part two -01 marks the color, when the color changes the number hast to change into -02 and so on. Part three marks the size. There are a few products which have the same name but differ in material. This can only be seen in the producers item number. It´s very important that these items get a different item number. See examples attached. 2) Price changes: prices for articles change regularly. Therefor I need an automatism which changes the prices in our excel files automatically. The idea is to copy the producer´s list with new prices into our file. Then an automatism should compare EAN numbers. If they match the new price should be copied into the line next to the EAN.
Identyfikator projektu: 14212323

Informację o projekcie

56 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
€250 EUR w 3 dni
5,0 (803 opinii)
8,7
8,7
56 freelancerzy składają oferty o średniej wysokości €117 EUR dla tej pracy
Awatar Użytkownika
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€200 EUR w 2 dni
4,9 (403 opinii)
8,2
8,2
Awatar Użytkownika
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
€250 EUR w 3 dni
4,9 (429 opinii)
8,1
8,1
Awatar Użytkownika
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 w 3 dni
4,9 (453 opinii)
7,8
7,8
Awatar Użytkownika
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3). If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
€90 EUR w 1 dzień
4,9 (290 opinii)
7,7
7,7
Awatar Użytkownika
Hello there, I can perfectly create two automatisms with full of accuracy and faster. We can discuss more details in message inbox. I am eagerly looking forward to your reply. Best regards, Raj
€200 EUR w 3 dni
4,8 (219 opinii)
7,2
7,2
Awatar Użytkownika
I can do it for you quickly and exactly .
€100 EUR w 3 dni
4,9 (119 opinii)
7,1
7,1
Awatar Użytkownika
Hi: I have a few questions: The numbering for the articles will be done only for new articles right? For old articles, only price has to be updated? To identify if a new articles has been added or it already exists in the list, Can i use the Item, Color and Size column? Please note that over 80% of my completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and ~5-star feedback on projects. Please connect with me to discuss your requirements in detail.
€50 EUR w 3 dni
4,9 (179 opinii)
7,1
7,1
Awatar Użytkownika
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. They speak for themselves. Best regards
€150 EUR w 4 dni
4,9 (294 opinii)
7,2
7,2
Awatar Użytkownika
Hi there, Your project immediately caught my eye and I feel I would be a great fit. I have over 15 years of corporate experience working in Excel creating advanced automated dashboards, reports and calculators which utilized numerous automated VBA scripts. I enjoy creating complex algorithms using Excel formulas to extract meaningful conclusions from Excel data to help clients use the data to improve their businesses. Also, automating tasks for my clients in Excel is one of my favorite things to do. I'd love the opportunity to build you a solution that would fulfill all of the automation requirements you have for your product pricebook. Do you have all of the available article names, colors and sizes? I think if I were to see your master file they would all be there and I could pivot them to see them all. The generated article # would be completely automated as well as the price updates. There would be a separate tab where you would paste in the producers new pricelist which would be bumped against your existing EAN#'s and prices. Hopefully I can hear more and we can work together! Thanks either way and best of luck, Shaun
€140 EUR w 3 dni
5,0 (93 opinii)
6,6
6,6
Awatar Użytkownika
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
€111 EUR w 1 dzień
4,9 (167 opinii)
6,5
6,5
Awatar Użytkownika
Hi I am a very experienced statistician and excel programmer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA, TABLEAU and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
€250 EUR w 3 dni
4,7 (87 opinii)
6,9
6,9
Awatar Użytkownika
Hi, CPA by qualification,having 6 plus years experience in reputed mnc, good exposure in accounting, bookkeeping, research and proficiency in excel,word,PPT and various accounting softwares like xero,myob, QuickBooks etc. Currently handling bookkeeping and accounting of various clients. Regards Pooja shah
€34 EUR w 3 dni
4,8 (52 opinii)
6,1
6,1
Awatar Użytkownika
Greetings for the day!!! We have strong experience in this field. We ensure 100% Quality with On-time deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc
€50 EUR w 3 dni
4,9 (56 opinii)
5,8
5,8
Awatar Użytkownika
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 fina l 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 one, maybe two days. Regards
€77 EUR w 2 dni
4,9 (64 opinii)
5,7
5,7
Awatar Użytkownika
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
€99 EUR w 2 dni
4,6 (102 opinii)
6,2
6,2
Awatar Użytkownika
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
€100 EUR w 1 dzień
4,8 (75 opinii)
5,6
5,6
Awatar Użytkownika
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating data with specific condition. It your example I can extract article number 1000-01-01 into 1000, 01 and 01 for Name, Color and Size. Then I can program accordingly. I also can scrape the price from web to update the price list automatically. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
€250 EUR w 5 dni
4,8 (90 opinii)
5,7
5,7
Awatar Użytkownika
Hi, we have excel expert with lot of experience. kindly give me one chance to show our capability. thanks
€250 EUR w 3 dni
4,9 (31 opinii)
5,1
5,1
Awatar Użytkownika
hi. I have 4+ years of experience in software development. I have built a number of Excel tools. here are couple of my past projects: ---( https://www.freelancer.com/jobs/project-5010518/ )--- and ---( https://www.freelancer.com/jobs/project-5135202/ )--- I'm very interested in your task and I have the relevant skills with experience. we can discuss further on chat. let's do it. waiting for your response...
€250 EUR w 8 dni
5,0 (8 opinii)
5,1
5,1
Awatar Użytkownika
Hi My name is Dan. I can automate this process in a very simple way which will be extremely user-friendly. Please message me and we can discuss further. Thanks! Regards Dan
€50 EUR w 1 dzień
5,0 (11 opinii)
4,6
4,6

O kliencie

Flaga GERMANY
Sauerlach, Germany
5,0
19
Zweryfikowana metoda płatności
Członek od paź 27, 2015

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.