Closed

VBA - excel data manipulation

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

Skills: Excel, Excel VBA, Excel Macros

See more: excel data manipulation, vba excel data oracle, excel data manipulation outsource, excel data manipulation sigma, example macros excel data manipulation, macros excel data manipulation examples, excel data manipulation macros, excel visual basic identify create number duplicate items column, free vba excel data entry reports, vba excel data entry text file, vba excel data extraction, vba excel data validation worksheet, web based vba excel data processing project, excel data manipulation script, excel data manipulation web, excel data manipulation job description, mysql excel data manipulation, vbscript excel data manipulation

About the Employer:
( 4 reviews ) Astoria, United States

Project ID: #22288229

47 freelancers are bidding on average $31 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$55 USD in 1 day
(733 Reviews)
8.5
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$50 USD in 1 day
(315 Reviews)
7.9
cgullapalli

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. -C More

$30 USD in 1 day
(857 Reviews)
8.0
bouslimi1979

Hi, I ll code the macro in few hours from now. I m ready to start. Thanks

$50 USD in 1 day
(277 Reviews)
7.7
P0L

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
(327 Reviews)
7.3
elqueabandona

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 i More

$30 USD in 2 days
(229 Reviews)
6.9
ksriniravi

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 ne More

$25 USD in 1 day
(190 Reviews)
6.8
Tanmoy236

"""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 mor More

$40 USD in 7 days
(235 Reviews)
6.9
datakillers

"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 you More

$30 USD in 1 day
(209 Reviews)
7.0
TechnoGuruu

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% cust More

$30 USD in 3 days
(84 Reviews)
6.1
Devrits

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 More

$30 USD in 1 day
(57 Reviews)
5.9
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, MS Word, Access, Outlook, Google Sheet, Access, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management ht More

$30 USD in 1 day
(56 Reviews)
6.0
citijayamala

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 i More

$150 USD in 3 days
(65 Reviews)
5.6
bhupendrayadav

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 More

$60 USD in 1 day
(37 Reviews)
5.4
shahinrahimi

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 sa More

$25 USD in 1 day
(47 Reviews)
5.0
Ahmed818

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- More

$19 USD in 6 days
(47 Reviews)
4.5
sparkingboy2010

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 More

$20 USD in 1 day
(43 Reviews)
4.7
ielucerotrad1

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, More

$30 USD in 1 day
(19 Reviews)
4.2
finecodervw

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 informati More

$75 USD in 4 days
(17 Reviews)
4.3
polite90

I have rich experience with excel vba. I have made many excel vba macros. please check my reviews. I can do it in one day.

$50 USD in 1 day
(4 Reviews)
4.2