Completed

Excel Macro to copy parts of cell regions to a new worksheet

Please see attached input spreadsheet and output spreadsheet.

- Create new WS "Aggregate" & "Volume"

- For each worksheet matching "Data-*"

- Copy and Transpose cells area matching "Host Name:" to "Aggregate" WS

- Copy and Paste cells area matching "Aggregate Name" to "Aggregate" WS

- Forward fill cells area matching "Host Name:" in the "Aggregate" WS

- Copy and Transpose cells area matching "Host Name:" to "Volume" WS

- Copy and Paste cells area matching "Volume Name" to "Volume" WS

- Forward fill cells area matching "Host Name:" in the "Volume" WS

Save as new Workbook

Skills: Excel, Visual Basic

See more: excel vba copy row to another workbook, copy columns from one excel sheet to another using macro, excel vba copy row, how to copy data from one excel workbook to another using macro, excel vba copy range to clipboard, excel vba copy range to another workbook, excel vba copy and insert row to another sheet, excel vba copy cell value and paste to another cell, excel macro copy cell web page, excel macro read unicode cell, excel macro copy cell time, free excel macro copy cell condition, excel macro copy cell next cell list, excel macro web query cell sheet, excel macro copy cell, macro copy part cell content excel, excel macro copy contents cell, excel macro find content cell, excel macro copy part cell paste, excel macro extract url cell

About the Employer:
( 3 reviews ) Blackburn South, Australia

Project ID: #17207915

Awarded to:

carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$25 AUD in 10 days
(30 Reviews)
4.9

19 freelancers are bidding on average $26 for this job

schoudhary1553

Hello, I can help with you in your project Excel Macro to copy parts of cell regions to a new worksheet. I have more than 5 years of experience in Excel, Visual Basic. We have worked on several similar projects befo More

$100 AUD in 1 day
(242 Reviews)
7.4
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to assist you with this project. I have experience with Excel, Visual Basic and macros as you could see in my reviews. Please contact me by chat to discu More

$30 AUD in 1 day
(84 Reviews)
5.1
$30 AUD in 1 day
(39 Reviews)
5.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

$40 AUD in 1 day
(34 Reviews)
5.0
teeares

I can write a macro in Excel to do this job. I have completed many tasks which required writing of macros.

$30 AUD in 3 days
(50 Reviews)
4.9
nurnga1218

Hi, I'm Ajiz and I'm an excel expert. I did some macro projects. I think I'm ready to do your job. I'm waiting for your reply. Thank you.

$30 AUD in 1 day
(38 Reviews)
4.5
thuyduongrands

Dear Mardam or Sir, You need an accountant . I am the one you need . I have great experience working as an Accounting throughout my career. I have over 10 years of experience and knowledge of accounting and good skill More

$25 AUD in 1 day
(7 Reviews)
3.8
$25 AUD in 1 day
(1 Review)
1.4
$20 AUD in 1 day
(1 Review)
1.0
adebajyoti

I am an expert in Excel vb macro . I have been working in this feild from a very long time. U can relay on me.i will deliver on time.

$20 AUD in 1 day
(0 Reviews)
0.0
subratnk

Hi, I am interested for your project. If you are interested, please confirm me. I have worked on similar type of projects Thanks

$25 AUD in 1 day
(0 Reviews)
0.0
TahaDiraoui

Hey so my name is Taha Diraoui and i'm from morocco , i'm a MS office master and also all kinds of office works . Hope u consider my proposal.

$10 AUD in 1 day
(0 Reviews)
0.0
$26 AUD in 1 day
(0 Reviews)
0.0
sumeetsinghcae25

I can do this job.

$10 AUD in 3 days
(0 Reviews)
0.0
$20 AUD in 3 days
(0 Reviews)
0.0
deeps2020

Dear reader i am willing to learn, motivated to work hard, and I will do my best every day to help you to achieve your goals.

$10 AUD in 2 days
(0 Reviews)
0.0
$10 AUD in 2 days
(0 Reviews)
0.0
$15 AUD in 1 day
(0 Reviews)
0.0