Find Jobs
Hire Freelancers

Build an excel macro from two different files

€30-250 EUR

En curso
Publicado hace más de 5 años

€30-250 EUR

Pagado a la entrega
We would like to deduct our physical stock after we sold our products. Actually we need the following things automated. We have the file A-that contains all our stock. From there we would like to start the macro. The macro should let us select the invoice file from our computer - The invoice is also an Excel file. - Unfold the hidden columns - Search for the ID in columns. The ID is in both files. - Values in the stock filed should be deducted by the number of sold goods in the invoice. One invoice has many product rows. - Do this with all rows in the invoice - When done select a filter in file A over the deducted positions. - Copy these files at the end of a list in another tab of file A - Copy specific data from two more different rows of the invoice to file A. - Put the amount of stock of the invoice from one column in file A to another column. The file Bestandsliste is file A. The attached has only 50 rows. Our normal file hast about 3000 rows. I would like to copy the macro then in the "real file".
ID del proyecto: 17653330

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi Marcus, This is Selim. I have already started the analysis, I think I can deliver till Sunday. Thank you,
€150 EUR en 3 días
4,9 (369 comentarios)
8,4
8,4
38 freelancers están ofertando un promedio de €145 EUR por este trabajo
Avatar del usuario
Dear Employer, I understand your job quite a bit and I will do the job for you. Please try me once. Do check my previous reviews. Thanks and Regards, Ash
€250 EUR en 3 días
5,0 (337 comentarios)
8,5
8,5
Avatar del usuario
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you with Build an excel macro from two different files I have more than 5 years of the experience in Data Entry, Data Processing, Excel, Software Architecture, Visual Basic Please ping me for more discussion. Thanks.
€250 EUR en 4 días
4,9 (597 comentarios)
8,5
8,5
Avatar del usuario
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to develop the necessary code to deduct your physical stoick. I read tyour requirements and tit's something I can develop for you. At then end the code will be copied to your real file. I've delivered more than 240 projects in the last 5 years and this makes me very comfortable with your task. I can deliver the project within 7 days including all required revisions for 200€. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Paris Pallas
€200 EUR en 7 días
5,0 (510 comentarios)
8,4
8,4
Avatar del usuario
I'm interested in your project very well. I've got an experience in jobs with skills of MS Excel and VBA. Please ping me to discuss about this project.
€155 EUR en 3 días
5,0 (251 comentarios)
7,8
7,8
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.
€200 EUR en 3 días
5,0 (501 comentarios)
8,0
8,0
Avatar del usuario
Hi there,I am Miljan,Excel VBA/Macro expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€177 EUR en 3 días
4,9 (217 comentarios)
8,0
8,0
Avatar del usuario
I have considerable experience with energy modules in Excel and VBA. I prepare dynamic financial modules for renewable energy platforms, upon demand; the financial modules include a driver’s tab, debt/grand repayment schedule, P&L, BS, and CF valuation (including IRR, NPV, DSCR, and terminal value). Also, I build modules in Excel that sets cost/sales prices for each level required. There is also a small VBA to manage the database and to keep on the historical prices. There is a report generator which enables to develop templates independently. The system is secured with usernames and passwords. About us Hi, I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.
€250 EUR en 3 días
4,9 (95 comentarios)
7,5
7,5
Avatar del usuario
Hi, I am an Excel macro expert and have experience in handling projects similar to yours. Let me know and we can discuss. Regards, Arul
€150 EUR en 3 días
5,0 (257 comentarios)
7,4
7,4
Avatar del usuario
Hello, As an experienced application developer, i am very much interested to do this job. I can create the required MACRO or a windows application by .Net if you like. Let's discuss more. Thanks
€160 EUR en 5 días
5,0 (261 comentarios)
7,6
7,6
Avatar del usuario
"""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. """
€120 EUR en 3 días
4,9 (280 comentarios)
7,1
7,1
Avatar del usuario
I am an Excel expert with a lot of experience in creating complex formulas and macros. Feel free to contact me for details.
€100 EUR en 3 días
4,9 (237 comentarios)
7,1
7,1
Avatar del usuario
I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
€80 EUR en 3 días
5,0 (58 comentarios)
6,6
6,6
Avatar del usuario
Hi, Being experienced in working on several excel/vba/macro related projects of various complexities, i can take up the task to complete as mentioned in the description requirement. I assure you of quick and efficient solution, and available with bandwidth to start on it. Waiting for your response for more discussion in detail and start it. Thanks.
€66 EUR en 3 días
4,8 (139 comentarios)
6,2
6,2
Avatar del usuario
Sir, I am very able to create a excel macro and can do your project as per requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards
€138 EUR en 3 días
4,7 (113 comentarios)
6,3
6,3
Avatar del usuario
Hello there, as an excel and VBA expert, i can write such a macro to accomplish your described tasks. Please contact me and let us talk more about your project. Thanks
€100 EUR en 3 días
5,0 (90 comentarios)
6,0
6,0
Avatar del usuario
I can write a macro to deduct the stocks and generate the output as per the conditions specified I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
€150 EUR en 3 días
4,9 (106 comentarios)
6,2
6,2
Avatar del usuario
am not a random bidder.. Please ping me if you are interseted wtih my propoal and shrae more detai.. thank you..
€250 EUR en 3 días
4,9 (30 comentarios)
5,1
5,1
Avatar del usuario
Hey, I am an excel VBA expert and went through your project description. I have done many projects like these with multiple user logins. Each with their own usage rights. I have made point of sale software and stock inventory manager as well. This project is very similar to that. Hope you find my offer useful and we can start our discussion soon. Waiting to chat with you soon! Thanks Sajid Khan
€130 EUR en 3 días
4,2 (69 comentarios)
5,8
5,8
Avatar del usuario
Hello, I understood the first part, Get the invoice, drop the items in the invoice from the inventory. For the second part we need to talk, but I don't think it will be hard. I have completed many similar projects, way harder than yours. Best Regards, Serdar Yalcin
€60 EUR en 3 días
5,0 (25 comentarios)
4,6
4,6
Avatar del usuario
Hi, my name is Deniz. I am 5-star excel & vba coding expert. I am interested in your project and ready to start once you award the job to me. Cheers,
€150 EUR en 3 días
4,7 (10 comentarios)
5,2
5,2

Sobre este cliente

Bandera de AUSTRIA
Wien, Austria
5,0
5
Forma de pago verificada
Miembro desde mar 29, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.