VB code to create new worksheet based on cell range

Hello everyone,

Please excuse my lack of knowledge on this subject. I am trying to find a way to create worksheets based on data within a particular range of cells.

I have attached an example of my spreadsheet.
example.docx

What I would like to do is create a new worksheet if data is in any cell in column A and in the worksheet have all data for from rows associated with that entry in column A.

From my example a new worksheet would be created call John. In the New worksheet all data in the range of A1-D4 would be created. The next worksheet would be Steve and the data created would be from A5-D13 and so on. Can this be done? Any assistance would be greatly appreciated.

Try this:

Please Login or Register  to view this content.