Sending Information to a new Workbook - Code

[cwalker6]

I am trying to get this to sort out to a new workbook instead of a worksheet. There are only two components in C column, so there should only be 2 new workbooks created. I am a little unfamiliar with the terminology for the workbooks. Thank you.

Please Login or Register  to view this content.

[rylo]

Hi

Before the line

Please Login or Register  to view this content.

add the code

Please Login or Register  to view this content.

This will move all the sheets except the first one to new workbooks.

HTH

rylo

[cwalker6]

That worked perfectly! Thank you. It copies the input sheet and puts it in a new workbook also. Is there a way I can block that? I just want the sorted versions making new workbooks. Thanks again!

[rylo]

Hi

Change the lowest number in the loop counts down. Currently it is 2, so it will only ignore the first sheet. That is where I thought the input sheet was placed. So if you want to only copy out from sheet3 starting from the left, then change the number to 3.

rylo

[cwalker6]

Thank you thank you thank you!