Find Jobs
Hire Freelancers

Excel Table Filter through formula - VBA or Macro

€8-30 EUR

Terminado
Publicado hace más de 5 años

€8-30 EUR

Pagado a la entrega
Hello, I have a table in sheet 1 and want in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe via VBA or Macro. So that always when the sheet 1 1 is being replaced by a new report I click on a button in sheet 2 and it gives me what I want to see.
ID del proyecto: 17836498

Información sobre el proyecto

17 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
I am an Excel expert with a lot of experience in VBA and complex formulas. I am confident that I am the best freelancer for this project. Feel free to contact me so we can discuss the details of this project.
€20 EUR en 1 día
4,9 (241 comentarios)
7,1
7,1
17 freelancers están ofertando un promedio de €33 EUR por este trabajo
Avatar del usuario
Hello, Hope you are doing well. I can help with your project Excel Table Filter through formula - VBA or Macro. I can assure you the quality job. I have good experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! Please have a look at my portfolio below: https://www.freelancer.com/u/schoudhary1553 We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
€39 EUR en 1 día
4,9 (662 comentarios)
8,6
8,6
Avatar del usuario
Hello client I understand what is to be done in this project. I will provide a button which will fetch the data from sheet 1 to 2 depending on the filter you provide. Kindly contact me. Roy
€30 EUR en 1 día
5,0 (509 comentarios)
7,8
7,8
Avatar del usuario
Hello , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming. I can complete task within time with 100% accuracy. With Regards, Sai
€30 EUR en 1 día
4,9 (493 comentarios)
7,8
7,8
Avatar del usuario
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
€29 EUR en 1 día
4,9 (178 comentarios)
6,9
6,9
Avatar del usuario
Hello. I have rich experiences in Excel and Pivot table. I'm interest to your project. Contact me please. Thanks.
€30 EUR en 1 día
4,8 (115 comentarios)
6,1
6,1
Avatar del usuario
Hi Good Day! I can help you to complete your VBA works in less than a day. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
€15 EUR en 0 día
4,8 (82 comentarios)
5,5
5,5
Avatar del usuario
Please share the sample excel sheet which you hvae with the requirement.. Please ping me if you are OK with my bid rate and thank you..
€100 EUR en 1 día
4,9 (30 comentarios)
5,1
5,1
Avatar del usuario
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro, VBA etc. thanks
€34 EUR en 1 día
5,0 (38 comentarios)
5,0
5,0
Avatar del usuario
Hello sir Welcome in my profile appreciate if you contact me to see how can work on your project , I am cost engineer and deal with huge data base for different fields in mega projects ... and expert in excel and can built dynamic database to can easy update any time by your self Thanks
€30 EUR en 1 día
5,0 (24 comentarios)
5,0
5,0
Avatar del usuario
Erstellen von Excel Macro oder VBA Code. Guten Tag, ich bin professioneller Software-Entwickler mit viel Erfahrung im Bereich Automatisierung in Excel oder Word. Ich kann ihre Wünsche ohne Probleme erfüllen. Für weitere Informationen können sie mich gerne jederzeit kontaktieren. Mit freundlichen Grüßen, Julian Katzwinkel
€50 EUR en 2 días
4,9 (10 comentarios)
4,2
4,2
Avatar del usuario
About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro coding for repetitive tasks. • Have worked directly with client for an MNC IT Company. • High Accuracy. • Work in tight deadline. • Fine tuning possible after final delivery.
€20 EUR en 1 día
4,9 (29 comentarios)
4,0
4,0
Avatar del usuario
Hi I am Premkumar. I saw your proposal on Freelancer site. I placed my bit and I can do well and deliver correct time .
€24 EUR en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Work with Excel for more than 20 years. Work with all kind of formulas including searching via Index, match and vlookup functions. Building search based on VBA codes based on date, text or numbers. Like any Excel official. We like to utilize the built-in functions to its maximum extent before thinking about VBA code to avoid Excel revisions impact due to VBA changes. Also, I have completed: 1. We have done many Excel sheets that validate all fields based on certain criteria like text length or restricted field entries. 2. Using OCR we convert all data from pdf or any other non-textual format to Excel tables. Sure, we have to review all converted data manually. 3. We have done many Excel that is using Website data like currency exchange rates to do some financial calculations. 4. We have built a complete tracking system for Cryptocurrency transactions and report both P/L and the current situation. It was mainly tracking and reporting excel. 5. We have created a complete timesheets system on Excel to track the time Vs. projects and report the projects hours and Ideal time.
€23 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de GERMANY
Offenbach, Germany
4,5
6
Forma de pago verificada
Miembro desde ene 1, 2017

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.