VBA: Create new sheets based on cell value and copy data

[Metrazal]

I need to copy data from one sheet into multiple sheets and name the new sheets using data in column A. In the attached example spreadsheet my final result would have four sheets: A7402, B7402, C7402, and Data. Sheet A7402 would contain 3 rows (including header) and all 9 columns. Sheet B7402 would contain 9 rows (including header) and all 9 columns. Sheet C7402 would contain 5 rows (including header) and all 9 columns. The Sheet Data would remain the same. Any help would be appreciated.


Thanks,

Met

[JieJenn]

Try

Please Login or Register  to view this content.

[stnkynts]

Another

Please Login or Register  to view this content.

[Metrazal]

Thanks for the responses. Stnkynts, I have been trying to use your code but I am executing it through Access after exporting an excel file. I am having some issues adapting the script to work through access. Any help would be appreciated.

Sorry for the delayed responses on my end but I have had issues connecting to the forum due to Websense.

Thanks again,
Met

[Metrazal]

Figured out my problem. It was an issue with one of my variables. Once again thanks for the help guys!


Met