Find Jobs
Hire Freelancers

Excel compare and mark items

$10-30 USD

Zamknięte
Opublikowano ponad 5 lat temu

$10-30 USD

Płatne przy odbiorze
Hello, I need some work for excel to be done. We have inventory lists in excel that is large file. We would like to be able to scan barcode and check if such an entry already exists. If it exists this entry should be marked green. if not than it should be written in a special column . Text in barcode are only numbers. We need some kind of function to do that, or macro or something. Hoe I explained well, for all other questions just contact me.
Identyfikator projektu: 18035647

Informację o projekcie

24 ofert
Zdalny projekt
Aktywny 5 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
24 freelancerzy składają oferty o średniej wysokości $36 USD dla tej pracy
Awatar Użytkownika
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Visual Basic. Please ping me for more discussion.
$35 USD w 1 dzień
4,9 (310 opinii)
7,8
7,8
Awatar Użytkownika
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$30 USD w 1 dzień
4,9 (195 opinii)
6,7
6,7
Awatar Użytkownika
Hi There, I can do this task perfectly for you. Just send me the files and first i will do the task, and if you are fine with the solution, later you can offer me the job. Please refer my profile to see my reliability. Best regards Priyal
$25 USD w 1 dzień
5,0 (191 opinii)
6,7
6,7
Awatar Użytkownika
Hello Sir Im excel VBA macro expert :) i can do build macro for scan barcode in your database please give me this job and im able to start working now Thank You Galih AP
$30 USD w 0 dzień
4,9 (337 opinii)
7,0
7,0
Awatar Użytkownika
Hi Sir I will write a macro to check the barcode and mark it green if it is already present or else should be written in a special column Regards
$25 USD w 1 dzień
5,0 (312 opinii)
6,4
6,4
Awatar Użytkownika
Hi, As per given details Its data entry and excel related task. I have great experience in all kind of backend support. I am good in lead generation, internet research, market research, data entry, data processing and all kind of backend support. I can give you best quality output with fast turn around time in competitive price Thanks
$35 USD w 1 dzień
4,9 (44 opinii)
5,2
5,2
Awatar Użytkownika
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will create a Macro to accomplish your requirements. Macro will give you a TextBox where you can scan barcode and then it will search for scanned barcode into specific column. If found then row will turn green otherwise it will store it into special column. I have understood your requirements clearly. So, I can do this job nicely. 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 Ready to start please reply soon. Thanks, Virendra
$30 USD w 1 dzień
4,8 (75 opinii)
5,4
5,4
Awatar Użytkownika
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD w 3 dni
4,8 (59 opinii)
5,5
5,5
Awatar Użytkownika
I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data anlysis, data automation, financial modeling and various other computations, analysis and automation.
$20 USD w 1 dzień
4,7 (43 opinii)
5,3
5,3
Awatar Użytkownika
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$25 USD w 1 dzień
4,9 (32 opinii)
4,9
4,9
Awatar Użytkownika
Hi, I am an Excel Expert with very good knowledge of VBA, formulas, Macros. I can make this function that will find and mark on logical conditions Please come on chat for more details. Thank you Awaiting your response.
$30 USD w 1 dzień
4,3 (41 opinii)
4,4
4,4
Awatar Użytkownika
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards " I would love to help you in your " " Project. We'd like to help you with confidence and satisfying results. "I’m an efficient MS Office,Excel Sheet and Data Entry Worker. If you consider me for the project, I will try my level best to complete your task within our committed deadline. Initial milestone "
$30 USD w 5 dni
4,9 (23 opinii)
4,1
4,1
Awatar Użytkownika
Dear Tomislav, I am interested and available to work on your project. with typically detail oriented person, I am able to work on your project with high accuracy & best quality work. I have read through your project description and available to do it immediately. below is my proposal: ### Proposal ### I will create user form/interface for the user to scan the bar-code with highlight either data already exist or new add into data base. ################ Hopefully you will award the project to me. Looking forward to hearing from you soon. Thanks & Best Regards, GS Anggara You may check my latest portfolio and client review on below link: https://www.freelancer.com/u/gsanggara
$25 USD w 0 dzień
4,9 (19 opinii)
3,6
3,6
Awatar Użytkownika
As an advanced excel user with valuable Financial / Analytical and Data Entry experience, I would be grateful if you would review my profile for the position advertised. Having worked at high levels within Finance, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offer. Also have vast experience in developing financial models via Excel (both basic and advanced).
$30 USD w 1 dzień
5,0 (2 opinii)
3,1
3,1
Awatar Użytkownika
Hello May I ask how many entries there are. can I see a sample for barcode? I can easily develop a program for your job, at the least price. If possible, please send me a message to discuss the details. Thank you for your valuable time & consideration. Regards
$10 USD w 2 dni
4,9 (12 opinii)
3,0
3,0
Awatar Użytkownika
About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro coding for complex tasks possible. • Have worked directly with client for an MNC IT Company. • High Accuracy. • Work in tight deadline.
$25 USD w 1 dzień
4,9 (12 opinii)
3,2
3,2
Awatar Użytkownika
Hi First you need to identify if it exists. Try VLOOKUP Function example, colum A has all existing CODE in cell D1 you put the Code to search in cell E1 you write the formula =vlookup(D1, A:A, 1, false) if the result is #N/A, the code you are searching is not in the list If you found it, the code will be written here. For automaticaly write the "unknown" code elswhere you need a macro. But if you work with barcodescanner, it should scan, write the code, and move to the next cell Simply, copy/paste the E1 formula to 2000 rows for example. Then select D1, and start scanning, all E cells will be update as soon as you do your BEEP scan action. All this would solve your issue. All the best !
$30 USD w 1 dzień
5,0 (2 opinii)
3,2
3,2
Awatar Użytkownika
Using barcode reader, a code will be entered to excel cell. We can develop function to search and highlight found items for you. Also if not listed, it will be added as per your request. Please share sample file. Thanks.
$111 USD w 2 dni
5,0 (3 opinii)
2,8
2,8
Awatar Użytkownika
kindly share your project details so i can help you out i will do the work in high quality and low price thanks
$25 USD w 1 dzień
5,0 (5 opinii)
2,5
2,5
Awatar Użytkownika
Hello! Before I started to comment on your project, I wanted to tell you how grateful I am for having the opportunity to bid for this job. I am a new freelance and I have a hard time getting projects because I appear very low on the lists and I have few evaluations. The advantage of receiving few jobs, is that for me all the projects I get are very special and I treat them with a lot of affection, professionalism and with absolute dedication. Regarding your project, I'm used to working with bar codes for excel or access. In this case, it would simply be necessary to define a bit of code in VBA to make the desired changes when detecting that it already exists. Again, thanks for giving me the opportunity to bid. I remain at your disposal for any clarification. Best regards
$25 USD w 2 dni
5,0 (3 opinii)
1,5
1,5

O kliencie

Flaga CROATIA
Bisag, Croatia
0,0
0
Zweryfikowana metoda płatności
Członek od gru 28, 2011

Weryfikacja Klienta

Inne pracę od tego klienta

Legalize ilegal house
$30-250 USD
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.