Automate CSV creation with unique file names

[snuffnchess]

Attached is a small sample of data that I am trying to create individual CSV files with.

The Sheet "Sample Data" has 3 columns..... of which I have been doing a copy paste (row by row) of columns B and C into the file "sample template" A16 and B16... then doing a copy/paste values of A1:Z12 into a new file, and saving that file as a csv with a title of whatever the value in "Sample Template A16" is. See attached 10001.csv for sample output

Because eventually this will need to happen for over 200 different items, it is going to be a long and slow process to do it manually, and I was trying to find a way to automate it.

Is there a Macro that I can use to do this same thing? Sample Data and Sample Template do not necessarily need to be separate files if that makes what Im trying to do easier? Thank you in advance for your help

[Tinbendr]

Add a module and paste in this code.

Please Login or Register  to view this content.

[snuffnchess]

To which file do I add this module to??? Does it matter?

[snuffnchess]

Sorry... stupid question... I tried it out and it is ALMMMMMOOOSSSSTTTT there.

In the original Template file I am using a concatenate naming convention on the items in Column A to add in the 00-01 pcf, 01-02 pcf, etc....

The VB code is not utilizing that part of it, so the names for column A do not come out correct.... is there a way to fix that part of it???

[jindon]

Try

Please Login or Register  to view this content.

[Tinbendr]

I just assumed that the sample data would be changing and so was trying to prevent chaving to edit the template sheet. But as usual, I was thinking too much,

Here's the adjusted code.

Please Login or Register  to view this content.

[snuffnchess]

Thank you so very much! One of the ways that I learn is by looking at code and trying to figure it out... how to change it, and what the changes will do. This has helped me understand a lot more on the VB side.

One question that I have is, if the initial sample data size were to grow to say 100 lines, 1000 lines, etc Is the change that would need to occur be in the

Please Login or Register  to view this content.

part? And just update that 26 to however many rows there are without the header row included???

[Tinbendr]

It's the line before.

I is rows, J is Columns.

If you want to make that dynamic as well, you'll have to explain where the suffix of the Name comes from.

I would move B16 to a variable so we could use a LastRow function to make the template dynamic.

[Tinbendr]

Here is an updated file that moved the B16 to A1 for dynamic template.

Please Login or Register  to view this content.

[snuffnchess]

Thank you again for the info. I will play around with it and let you knowing I have any other questions. Thank you for adding notes to the code so that I can learn from it as well. Truly awesome.