Find Jobs
Hire Freelancers

Build an excel sheet with forumlas and macros.

£20-250 GBP

Opravljeno
Objavljeno pred skoraj 5 leti

£20-250 GBP

Plačilo ob dostavi
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 projekta: 20028260

Več o projektu

21 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
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 v 1 dnevu
5,0 (174 ocen)
6,2
6,2
21 freelancerjev je oddalo ponudbo s povprečno vrednostjo £104 GBP za to delo
Avatar uporabnika
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 v 3 dneh
4,9 (90 ocen)
7,1
7,1
Avatar uporabnika
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 v 3 dneh
5,0 (106 ocen)
6,3
6,3
Avatar uporabnika
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 v 1 dnevu
4,9 (40 ocen)
5,6
5,6
Avatar uporabnika
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 v 2 dneh
4,7 (58 ocen)
5,6
5,6
Avatar uporabnika
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 v 3 dneh
5,0 (21 ocen)
4,9
4,9
Avatar uporabnika
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 v 5 dneh
5,0 (3 ocen)
3,3
3,3
Avatar uporabnika
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 v 3 dneh
4,9 (7 ocen)
2,8
2,8
Avatar uporabnika
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 v 1 dnevu
5,0 (1 ocena)
1,1
1,1
Avatar uporabnika
I am an expert in excel vba macros for more than 9yrs plz call 9884276677 if you require any support Thanks Anitha
£111 GBP v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 5 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 4 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,8
0,8
Avatar uporabnika
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 v 5 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED KINGDOM
Glasgow, United Kingdom
5,0
1
Plačilna metoda je verificirana
Član(ica) od jun. 18, 2019

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.