Find Jobs
Hire Freelancers

Build an excel sheet with forumlas and macros.

£20-250 GBP

Completed
Posted almost 5 years ago

£20-250 GBP

Paid on delivery
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.
Project ID: 20028260

About the project

21 proposals
Remote project
Active 5 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
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 in 1 day
5.0 (174 reviews)
6.2
6.2
21 freelancers are bidding on average £104 GBP for this job
User Avatar
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 in 3 days
4.9 (90 reviews)
7.1
7.1
User Avatar
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 in 3 days
5.0 (106 reviews)
6.3
6.3
User Avatar
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 in 1 day
4.9 (40 reviews)
5.6
5.6
User Avatar
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 in 2 days
4.7 (58 reviews)
5.6
5.6
User Avatar
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 in 3 days
5.0 (21 reviews)
4.9
4.9
User Avatar
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 in 5 days
5.0 (3 reviews)
3.3
3.3
User Avatar
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 in 3 days
4.9 (7 reviews)
2.8
2.8
User Avatar
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 in 1 day
5.0 (1 review)
1.1
1.1
User Avatar
I am an expert in excel vba macros for more than 9yrs plz call 9884276677 if you require any support Thanks Anitha
£111 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.8
0.8
User Avatar
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 in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Glasgow, United Kingdom
5.0
1
Payment method verified
Member since Jun 18, 2019

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.