Find Jobs
Hire Freelancers

Build an excel sheet with forumlas and macros.

£20-250 GBP

Terminado
Publicado hace casi 5 años

£20-250 GBP

Pagado a la entrega
Hello, i am looking to create an excel document that allows me to populate the first sheet and then it will pull the information to the corresponding sheet it relates too. For example. If i am putting in the figure for the sales department, i want it to pull everything to the sales department tab (everything on that line). If i put a figure under the design team, i want to pull that under to the design tab. I know how to do it using advanced filter but that only works one time, if i then add more lines it doesnt pull it through automatically.
ID del proyecto: 20028260

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 5 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
Hello there, I am an Excel expert and I will create some macros for you. If you alread knew how to do it manually, that great. We can complete it in 1 hour I think. Please contact me and I will automate all your task. Thank you.
£30 GBP en 1 día
5,0 (174 comentarios)
6,2
6,2
21 freelancers están ofertando un promedio de £104 GBP por este trabajo
Avatar del usuario
Hi, I am an expert and guru in Financial, Math and Microsoft Office/Excel/VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database. , especially with exporting databases to and vice versa (+ automation with VBA). 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). I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. With these skills, I develop financial modules including business valuation methodology & ratios (NPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, ROI, LTV, LTV, Terminal Value, TWR, S-Curve, sensitive analysis, optimisation, correlation and regression) for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios).
£250 GBP en 3 días
4,9 (90 comentarios)
7,1
7,1
Avatar del usuario
With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write the macro as requested. Would be great if you can provide the sample of your workbook for more context, kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
£100 GBP en 3 días
5,0 (106 comentarios)
6,3
6,3
Avatar del usuario
I am postgraduate (MBA) with more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
£60 GBP en 1 día
4,9 (40 comentarios)
5,6
5,6
Avatar del usuario
I can definitely help you with that. 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 for performing Data Analysis, Automation and Data Visualization. I will be happy to discuss in detail how I am highly suitable for this project.
£70 GBP en 2 días
4,7 (58 comentarios)
5,6
5,6
Avatar del usuario
Hello I am an expert in excel and macros and have a vast knowledge of formulas plus I am a Chartered Accountant having 10 years of experience in preparing and updating multilple excel based documents. I sure can help you. I would be glad to see the existing sheet and discuss more. Kind regards, Anjul
£50 GBP en 3 días
5,0 (21 comentarios)
4,9
4,9
Avatar del usuario
Combined twenty years of accounting, analytical and project management experience (as qualified accountant)  Enthusiastic, proactive and accomplished successful roles within the financial services sector.  Advanced excel user who has developed many various financial models.
£166 GBP en 5 días
5,0 (3 comentarios)
3,3
3,3
Avatar del usuario
I can make this idea by Excel vba and macros. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication,vba, Microsoft office(Word, Excel, PowerPoint, Access).a Best Regards. Khaled Alflah
£48 GBP en 3 días
4,9 (7 comentarios)
2,8
2,8
Avatar del usuario
hi I am an expert in VBA Excel, I have 6 years of experience and a lot of skills in processing data in Excel using VBA. You will get the correct and fast data. I can make your request quickly.
£55 GBP en 1 día
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
I am an expert in excel vba macros for more than 9yrs plz call 9884276677 if you require any support Thanks Anitha
£111 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear authorized, I am industrial engineer. I want to work on your job. If you look at my profile, I worked as a system consultant. I did to consultanty enterprises for SAP Business One Program. I have some experiences for this job. I want to using these. I have skills that a good organization and planning. Also, I lectured about ERP at university for two years. I have worked on many projects based on Excel VBA(Macros). For two years, I lectured Excel VBA(Macros) applications at university. You can be sure that I will fulfill the requirements in your project. To your information.
£75 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have more than 4 years experience in this type of jobs. I will use lookup ,pivot and if required macros to achieve your required data. You can immediately message me your problem and I can start now. You can pay me as you like as I want to build my profile.
£50 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have an experience on making a database. The database can be extracted as your request. Logic about how to design the database is the most important thing to do. I promise that i will give my best to you.
£200 GBP en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can do This for you with in a limited time, although i can make arrangement that you can Reconcile every such Relationships in the data. Give it a try to me. Hoping for your final call. Thankyou Relevant Skills and Experience Arrangements and Presenting your data in such a way that you do not need any further effort to arrange it. Simply you can use it as such as it give you.
£150 GBP en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I do data analysis full time as my day job. If you award me the project I should be able to complete this work today.
£50 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am a data analyst and expert in excel and VBA so I can help you with your project efficiently and quicly ! i can solve your problem and help you with your reports ! Ben
£135 GBP en 3 días
0,0 (0 comentarios)
0,8
0,8
Avatar del usuario
Hi, I am a VBA Expert and do individual projects with a dedicated team who has immense knowledge in VBA. Give us a chance and you'll see the best deliverables in the industry. pricing and timings can depend on type of work level. I do need to see your sheet and understand the project completely. Hope to hear from you soon.
£111 GBP en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Glasgow, United Kingdom
5,0
1
Forma de pago verificada
Miembro desde jun 18, 2019

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.