Automatically Parsing a Spreadsheet

[scm24]

The code below attempts to: parse the worksheet COPY_APR_All_States based upon the state (column "F") by making a new worksheet (named by State, the "holdState" variable) for every state found in column "F" of COPY_APR_All_States, and then adding the respective rows to the new worksheet.

I have checked that COPY_APR_All_States is populated and sorted correctly, and I have added Error Checking to the Sub. However, the code below only creates a Worksheet for DC (there's another 12 states in COPY_APR) and does not copy any of the rows. I don't receive any errors when this task is executed or completed.

Any ideas on what is wrong here?

Thanks in advance!

Please Login or Register  to view this content.

[JBeaucaire]

A sample workbook to try this on, too, would be most helpful. Click on GO ADVANCED in a new message and use the paperclip icon to upload on for us. The problem could be in the dataset.