VBA - excel data manipulation

종료 등록 시간: 4년 전 착불
종료 착불

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 VBA Excel Macros

프로젝트 ID: #22288229

프로젝트 소개

41 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

이 일자리에 대한 프리랜서 41 명의 평균 입찰가: $32

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 기타

$30 USD (1일 이내)
(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 기타

$30 USD (1일 이내)
(467 리뷰)
8.0
bouslimi1979

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

$50 USD (1일 이내)
(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 (1일 이내)
(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 기타

$30 USD (2일 이내)
(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 기타

$40 USD (7일 이내)
(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 기타

$25 USD (1일 이내)
(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 기타

$30 USD (3일 이내)
(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 기타

$30 USD (1일 이내)
(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 기타

$75 USD (4일 이내)
(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 기타

$60 USD (1일 이내)
(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 기타

$150 USD (3일 이내)
(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 기타

$25 USD (1일 이내)
(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 기타

$20 USD (1일 이내)
(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 (1일 이내)
(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- 기타

$19 USD (6일 이내)
(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, 기타

$30 USD (1일 이내)
(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 기타

$30 USD (1일 이내)
(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 기타

$20 USD (1일 이내)
(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 기타

$35 USD (2일 이내)
(4 리뷰)
3.8