Write VBA code to Copy Data to New Worksheets

In the attached template write me a macro that takes the data in Columns B-I and pastes in a new worksheet, naming the worksheet the relevant name in column A.

The final Output of the Macro is that I should have the following 3 Worksheets:

Test1 - containing data from B2 to I3 of the Template worksheet

Test2 - containing data from B4 to I7 of the Template worksheet

Test3 - containing data from B8 to I11 of the Template worksheet

Need within 2 hours preferably as soon as possible.

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: Write Python code for Face & Body Detection in security camera, Write Python code for Face & Body Detection in security camera video , how to write vba code in excel, macro to copy data from one sheet to another based on criteria, excel vba copy data from another workbook without opening, macro to copy specific columns from one worksheet to another worksheet, excel vba copy sheet from one workbook to another, excel vba copy range to another sheet with formatting, how to copy cells from one sheet to another in excel using vba, copy data from one workbook to another in excel vba, excel vba copy cell value and paste to another cell, excel, visual basic for apps, write vba code extract data display listbox dropdownbox, vba code copy paste special, vba code copy web page excel, ms access vba code copy paste subform form, vba code copy file ftp site, vba code excel data analysis, vba code extract data email

About the Employer:
( 23 reviews ) Adelaide, Australia

Project ID: #16091861

Awarded to:


Hi, I can work on it with in hour. Kindly let me know over chat. You can review my profile to know more about my skills and experiences required for this work. Regards.

$25 AUD in 1 day
(34 Reviews)

6 freelancers are bidding on average $26 for this job


HI, I am good at Excel and vba. I have referred the attached file. I can transfer the data from the template to individual sheets. I can provide solution in 1 hour. -Chandra

$30 AUD in 0 days
(774 Reviews)

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 AUD in 1 day
(276 Reviews)

HELLO sir I can achieve this in less than 2 hours using vba excel please contact me for more details best regards

$30 AUD in 1 day
(18 Reviews)

Hello I can help you to get it done quickly. I have 10+ years experience in Microsoft Technologies development Like MS SQL, Visual Basic, MS Access and Excel. Thanks Guru Venkat

$25 AUD in 1 day
(19 Reviews)

i can do it , because it my field in education , i good in excel chat me and i will show you some projects

$15 AUD in 1 day
(0 Reviews)