change to worksheet to create files using VBA

[steve400243]

Hello, The attached worksheet is used to generate files, a user will copy and paste any of the "Master Number"s from the DATA Tab to cell C3 on theCFS SHEET and the data will transfer over.

I am looking to get this done automatically amending the existing VBA. I would like to have an option button on the DATA tab where if the user clicks this button it will loop thru all the master numbers and create the files and save them to my desktop as the masterbill number. Let me know if this sounds like something that can be done. with this example data it would create 4 files.

[bakerman2]

It certainly can be done but what exactly do you want saved, CFS sheet only, multiple sheets, entire workbook ????

[bakerman2]

Try this. It saves the CFS sheet as seperate file for each Master Number.

Please Login or Register  to view this content.

[steve400243]

That is awesome bakerman2, thank you very much. I will need it to save the Devan sheet, and Freight tags also in each file. Sorry for not mentioning that. I really appreciate your help.

[bakerman2]

Change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[steve400243]

Awesome - I was trying to add in the other sheets on this line. So much to learn. Have a nice weekend, but this is now working as needed. Relly appreciate it!

Please Login or Register  to view this content.

[bakerman2]

Have a nice weekend

A nice weekend to you too but I think bakerman says it all (yes I really am a selfemployed baker )

Glad to help and thanks for rep+.

PS You can remove the WorkSheetChange-event from CFS sheet because all is handled in the code I gave you.

[steve400243]

Hi Baker, dont know if I need another post for this or not, But I wanted you to look at this as you solved the first part. I need to be able to print the FREIGHT TAGS for each file also. This was done before with this code. Any ideas how to get this worked into the code?

Please Login or Register  to view this content.

[bakerman2]

Give this a whirl.

Please Login or Register  to view this content.

[steve400243]

Thanks again Baker. I appreciate the time you put into this.