VBA - excel data manipulation

Imefungwa Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

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

Excel Excel VBA Excel Macros

Kitambulisho cha Mradi: #22288229

Kuhusu mradi

41 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

41 wafanyakazi huru wanazabuni wastani wa $32 kwa kazi hii

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 Zaidi

$30 USD kwa siku 1
(Maoni 1026)
8.2
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 Zaidi

$30 USD kwa siku 1
(Maoni 467)
8.0
bouslimi1979

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

$50 USD kwa siku 1
(Maoni 305)
7.9
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 kwa siku 1
(Maoni 476)
8.0
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 Zaidi

$30 USD kwa siku 2
(Maoni 305)
7.4
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 Zaidi

$40 USD kwa siku 7
(Maoni 264)
7.1
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 Zaidi

$25 USD kwa siku 1
(Maoni 220)
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 Zaidi

$30 USD kwa siku 3
(Maoni 93)
6.5
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 Zaidi

$30 USD kwa siku 1
(Maoni 62)
6.1
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 Zaidi

$75 USD kwa siku 4
(Maoni 88)
6.2
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 Zaidi

$60 USD kwa siku 1
(Maoni 53)
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 Zaidi

$150 USD kwa siku 3
(Maoni 76)
6.1
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 Zaidi

$25 USD kwa siku 1
(Maoni 66)
6.1
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 Zaidi

$20 USD kwa siku 1
(Maoni 70)
5.4
davide0200

Hi, I've done this a lot of times. Draft for a robust solution will be delivered immediately after ordering. Cheers, Davide

$20 USD kwa siku 1
(Maoni 2)
4.9
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- Zaidi

$19 USD kwa siku 6
(Maoni 60)
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, Zaidi

$30 USD kwa siku 1
(Maoni 27)
4.5
MonisZafar

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 discus Zaidi

$30 USD kwa siku 1
(Maoni 24)
4.7
olaideejiwole

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 Zaidi

$20 USD kwa siku 1
(Maoni 9)
4.2
Altantsetseg

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 consta Zaidi

$35 USD kwa siku 2
(Maoni 4)
3.8