Find Jobs
Hire Freelancers

Ausführung von Excel-Arbeiten

$10-30 USD

Completed
Posted about 7 years ago

$10-30 USD

Paid on delivery
Hi, I just need some small filter function for an excel sheet. first function: I have two sheets in one excel file (see attached). On sheet "Drucker" you can find headline Asset ID (Colum B) On sheet "Audit" you can find Referenz 1 which is the same like Asset id. (Column F). I want that all lines in Sheet "Drucker" are marked green where Asset id is in Audit List Column F. Second function: I want to add Column "gedruckte Seiten" (H), "Zustand" (I), "Bemerkungen" (J) to the lines in Sheet Drucker where Asset id and Referenz 1 is the same. So add this values in column L, M , N in sheet "Drucker".
Project ID: 13433925

About the project

39 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
Awarded to:
User Avatar
Greetings! I have read your 2 requirements and completely understand what needs to be done. 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. Thanks in advance! Have a Great Weekend! Srinivasan Krishnamoorthi
$20 USD in 1 day
5.0 (211 reviews)
6.9
6.9
39 freelancers are bidding on average $31 USD for this job
User Avatar
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 am among niche bidders who 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. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$50 USD in 0 day
5.0 (783 reviews)
8.6
8.6
User Avatar
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
$70 USD in 1 day
4.9 (377 reviews)
8.1
8.1
User Avatar
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
$30 USD in 1 day
4.9 (424 reviews)
8.0
8.0
User Avatar
Hi. I have implemented what you need in your spreadsheet. Please do send me a message so that I can respond with the completed spreadsheet. Waiting to hear from you.
$10 USD in 0 day
5.0 (37 reviews)
7.2
7.2
User Avatar
Greetings, Your project sounds quite interesting and has caught my eye - I have over 15 years of corporate experience working in Excel creating advanced automated dashboards, reports and calculators which utilized many advanced formulas and functions. Your project makes perfect sense to me. I will use a VLOOKUP function to fulfill the first requirement to mark all lines on the drucker tab that have the same ID as on the audit tab, and then add in the new columns "gedruckte Seiten" (H), "Zustand" (I), "Bemerkungen" (J) to the drucker tab using most likely another VLOOKUP for each column from the asset ID. Hopefully we can work together! I can do this for you today no problem. Thanks either way and best of luck, Shaun
$30 USD in 1 day
5.0 (93 reviews)
6.6
6.6
User Avatar
Hello, I would like to work on your project, I have great experience using Excel and macros, vba, I have had many similar work before and I can deliver it within 1 day. Thank you. Regards
$30 USD in 0 day
5.0 (138 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of Excel/VBA exp. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD in 1 day
4.9 (175 reviews)
6.5
6.5
User Avatar
Hello, I am proficient with Excel and VBA and would love to help you. I can make a small macro that could work as you requested. Please contact me for more information.
$25 USD in 1 day
4.9 (140 reviews)
5.8
5.8
User Avatar
I am experienced at excel advanced functions and also VBA coding. I can conduct the project with full dedication,
$30 USD in 1 day
5.0 (9 reviews)
5.5
5.5
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. If you open chat I can send you a working mockup immediately. I can offer a macro doing the job for the case you need it for repetitive use for an extra $5. Regards
$20 USD in 0 day
4.9 (64 reviews)
5.7
5.7
User Avatar
-Can get the lines marked green in "Drucket" sheet based on the AssetID - And adding columns based on the values on the spreadsheet. - 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.
$30 USD in 2 days
4.7 (51 reviews)
6.1
6.1
User Avatar
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon,Cellpex,Costco,Yelp,etc., Hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details
$30 USD in 1 day
5.0 (50 reviews)
4.7
4.7
User Avatar
Hi, You need to add the columns "gedruckte Seiten" (H), "Zustand" (I), "Bemerkungen" (J) in the first sheet, if the Asset ID and Referenz1 matches. I can give the solution in a day. Let me know if you need more infor. Danke.
$25 USD in 1 day
5.0 (19 reviews)
4.8
4.8
User Avatar
Hi! I learned your file. It will take not more than two hours for me to complete your project. I'm able to start right now!
$25 USD in 0 day
5.0 (18 reviews)
4.4
4.4
User Avatar
Dear, These functions could be easily implement with VBA (macros). Could you accept this or you definitely need to be done with only excel builtin functions? I would do it with VBA for the price i'd placed. Best regards,
$25 USD in 1 day
4.7 (23 reviews)
4.9
4.9
User Avatar
Hi! I can help you! I have experience with excel and this shud be done quick! Lets chat to discuss further details!
$30 USD in 10 days
5.0 (1 review)
3.7
3.7
User Avatar
I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interactive KPI dashboards using pivot tables, slicers, and graphs. Projects range from long-term support of data analysis and visualization needs to short-term specific projects. Skills: - Excel/VBA Automation - Excel Dashboards & Reporting (Data Visualization) - QlikView/QlikSense/Tableau (Data Warehousing and Business Intelligence) - Microsoft Access (SQL) - SAS / R Language - Data Analytics (Executive Decks/Analysis - Key Results and Insights) - Commercial Insights and Analytics Once I receive a project, my biggest priority/focus is to ensure that quality work is delivered always on time. Give me an opportunity, I will deliver you the quality. Warm Regards, Rohit Ahuja | Mobile: +91-8527610117 |
$20 USD in 0 day
5.0 (7 reviews)
3.4
3.4
User Avatar
Hi, I can do this.
$20 USD in 1 day
5.0 (5 reviews)
2.8
2.8
User Avatar
I guarantee good quality of my work, so should a need for corrections arise after the project is completed, I will gladly do that for you.
$25 USD in 1 day
4.3 (15 reviews)
3.4
3.4
User Avatar
Guten Tag, ich habe professionelle Erfahrung mit MS Office, inklusive VBA Programmierung oder Erstellung von Business Excelsheets. Mit freundlichen Grüssen, Oliver Glas
$25 USD in 1 day
5.0 (2 reviews)
2.2
2.2

About the client

Flag of GERMANY
Balingen, Germany
5.0
9
Payment method verified
Member since Jun 17, 2016

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.