Want to Move Rows into New Workbooks by a Unique Identifier

I am trying to disaggregate an excel workbook. I would like to make separate workbooks for each unique value of my A column. I want to have all the column names (columns A through CM) and for the table design to remain the same. My current file has 58 unique values and over 8,000 rows. Later files will have many more unique values and thousands more rows. Please help!!!

I have almost 0 experience with VBA - I am a SAS girl, so I need step-by-step instructions.

'SHEET1 TO MANY WORKBOOKS

Here's a macro for parsing rows of data from one sheet to many workbooks based on one column, workbooks named for the same values in that column.

Sheet1 to Many Workbooks

The macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.


----------------
How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. update the parts marked in red on the website as they must be tweaked for your environment. The comments in each sections should make it clear what the needed tweaks relate to.
6. Get out of VBA (Press Alt+Q)
7. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.