Find Jobs
Hire Freelancers

VBA - excel data manipulation

$10-30 USD

Closed
Posted over 4 years ago

$10-30 USD

Paid on delivery
Need to create a macro for excel to pull the data from the reference sheet in the attached workbook to insert the rows for the portico columns and their corresponding %. Sheet 2 is an extract of the funds where we manually have to insert rows and the portfolio companies & percentages which always will = 100. sheet three is what I would like the macro to auto magical do. Pull the data from the reference sheet and insert rows based on the number of portfolio companies in that fund
Project ID: 22288229

About the project

41 proposals
Remote project
Active 4 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
41 freelancers are bidding on average $32 USD for this job
User Avatar
Hi, I am good at Excel and VBa. I have referred the file. I can transfer the data from reference sheet to the sheet like output. However, i would like to discuss further in the chat to get more clarity on the job. -Chandra
$30 USD in 1 day
5.0 (1026 reviews)
8.2
8.2
User Avatar
"Hi, I am good in your required project; I also have a great working experience of more than 10 years. To ensure please visit my profile and check customers satisfaction level. I will complete your project within your given deadline. Thank you. "
$30 USD in 1 day
4.9 (467 reviews)
8.0
8.0
User Avatar
Hi, I ll code the macro in few hours from now. I m ready to start. Thanks
$50 USD in 1 day
5.0 (305 reviews)
7.9
7.9
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
5.0 (476 reviews)
8.0
8.0
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$30 USD in 2 days
5.0 (305 reviews)
7.4
7.4
User Avatar
"""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 290+ 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. """
$40 USD in 7 days
4.9 (264 reviews)
7.1
7.1
User Avatar
Greetings! If I compare data in the Reference and Output sheets for the corresponding columns, there is a one to one match. Are you looking for auto update of Output based on Reference Worksheet? Rephrasing, do you need Output Sheet Col C, D and E to be updated automatically whenever Reference sheet column A, B and C are updated? I can write a macro for this scenario. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$25 USD in 1 day
5.0 (220 reviews)
7.0
7.0
User Avatar
Hi, As per requirements I will develop VBA macro for you as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed.I look forward to discussing the project with you and hopefully secure a long term working relationship. I am ready to work on this project now. Thanks and regards, Mohan
$30 USD in 3 days
5.0 (93 reviews)
6.5
6.5
User Avatar
Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects. 2* I can create the accurate DATABASE (EMAIL/CONTACTS/PERSONAL INFO etc*. 2* I can properly fill a Google Sheet/EXCEL/WORD. Have good working skills of Excel/PDF. 4* I am Expert in DATA ENTRY and do any kind of that work. 5* I can Find data from INTERNET RESEARCH/ WEB SCRAPING. 6* I can Work as a VIRTUAL ASSISTANT for daily any kind of task. 7* I can work as per client TIME ZONE if they want and provideS 15hrs services in a day. 8* I have 3YRS of good experience of as a VIRTUAL ASSISTANT and done various type of task. 9* I have the excellent skill of SEO/DIGITAL MARKETING/SOCIAL MEDIA MARKETING/MANAGEMENT. 10* I can create MEMES/posting,strategy for increasing likes,followers of social media. 11* I have expertise in WORDPRESS sites creating/product Uploading/WOOCOMMERCE. 12* I have Good skills in SHOPIFY, PRESTASHOP, MAGENTO etc for DROPSHIPPING. 13* I Can Write Optimized SEO friendly impressive articles for BLOG and get 1 rank. 14* I am fast Learner. Grab The instructions from client instantly and implement. 15* I can get 100% results and Give Guaranteed work satisfaction from client instructions. for work i am always available and take the challenges and never say no to work always be ready and be professional in work. thanks
$30 USD in 1 day
4.9 (62 reviews)
6.1
6.1
User Avatar
Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. Looking forward to working with you. Thanks & Regards FineCoder
$75 USD in 4 days
4.9 (88 reviews)
6.2
6.2
User Avatar
I can write a macro to pull the data from the reference sheet and insert rows based on the number of portfolio companies in that fund. Please find below a brief introduction of myself. I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$60 USD in 1 day
4.9 (53 reviews)
6.0
6.0
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD in 3 days
4.7 (76 reviews)
6.1
6.1
User Avatar
I have rich experience in VBA-Macro coding (API, Websacrping, Automation tasks, managing data, .....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
$25 USD in 1 day
4.6 (66 reviews)
6.1
6.1
User Avatar
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor
$20 USD in 1 day
4.8 (70 reviews)
5.4
5.4
User Avatar
Hi, I've done this a lot of times. Draft for a robust solution will be delivered immediately after ordering. Cheers, Davide
$20 USD in 1 day
5.0 (2 reviews)
4.9
4.9
User Avatar
Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs it is very easy for me to pull data from one sheet to another using excel vba coding samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$19 USD in 6 days
4.9 (60 reviews)
4.7
4.7
User Avatar
I can do the job and I can start right away. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$30 USD in 1 day
5.0 (27 reviews)
4.5
4.5
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I've project experience with VBA. If interested, we can discuss this further on chat.
$30 USD in 1 day
4.5 (24 reviews)
4.7
4.7
User Avatar
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language, Data Processing, Excel, Web Scraping, Web Search and Data Entry as well. I’m honest, creative and a unique person to carry out your tasks given to me. Leaving your project on our hand is privileged; we'll make sure that the project is done in a perfect way and do our best until you were satisfied. I would love to discuss this project with you and meet your exact requirements. I am confident I can provide you with top-notch materials that will fit your needs. I'm proud of my work on being professional, of the highest quality and always delivered on time.
$20 USD in 1 day
4.9 (9 reviews)
4.2
4.2
User Avatar
Hi. I have been experienced in programming including Excel VBA /macro / since 2000. During 2006-2013, I had been working as a senior developer for Financial system developed in MS Access which use VBA for coding constantly. Until now, I have been working with Excel macros and gained excellent knowledge and experience. I can complete your macro with your high satisfaction. Hope to hear from you back soon. Regards, Alta
$35 USD in 2 days
4.9 (4 reviews)
3.8
3.8

About the client

Flag of UNITED STATES
Astoria, United States
4.3
11
Payment method verified
Member since Sep 17, 2017

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.