Automatically Creating Workbook Files from Worksheet Data

Automatically Creating Workbook Files from Worksheet Data
I copied the VBA code from the link above that creates new workbooks based on the contents of the Master worksheet from msdn.microsoft web site

The code for this solution assumes the following:
The master worksheet that contains the list of region names is named REGION SHEET.
The first three rows of the master worksheet contain boilerplate information that will be copied to each new workbook.
The list of region names is in column B of the master worksheet, and the first name in the list is in cell B4.
The row for each region contains additional information that will be copied to the new workbook for that region.
Column A Column B Column C Column D
Row 1 Information 1
Row 2 Information 2
Row 3
Row 4 Region: North Reprentative: Peter
Row 5 Region: South Reprentative: Paul
Row 6 Region: East Reprentative: Steve
Row 7 Region: West Reprentative: James

Running the macro on this data should create four workbooks named North.xlsx, South.xlsx, East.xlsx, and West.xlsx. Each workbook should contain the first three rows of boilerplate data, followed by the row of information for that region.

When I run the macro, it is not working.
I want to adopt the VBA for another massive spread sheet which I am using at my workplace.
Can some expert edit the code and make it to work PLEASE

Maybe:

Please Login or Register  to view this content.