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

Project ID: #16091861