Moving rows of data to another excel sheet

[djfscouse]

Hi,

I have a script below that moves only one row of data from a csv file to an xls template and saves the filename as the that rows column A, but if I have more than one row with the same information except for the last 3 columns then I need them passed to the same template and saved.

This is difficult for me to explain so I hope somebody understands.

Please Login or Register  to view this content.

Thanks for any help,

David

[JOHN H. DAVIS]

Not so sure I understand. Looks to me that if you have more than one row, the above macro will work. Which columns are the last three columns? I guessed G, H I. I may be way off on this, let me know.

Please Login or Register  to view this content.

[djfscouse]

Thanks John,

I'm sorry what I put make no sense, here are the documents so you can see what happens when you run the macro in Orders.xls, it creates the packing lists for single item orders but for multiple item orders it overwrites the first row.

David

[djfscouse]

Hi,

I keep trying to add an if statement within the loop just before the save the filename portion that if the order number is the same on the next row then write the following code:

Please Login or Register  to view this content.

and if the same order number is on the next line again do the following:

Please Login or Register  to view this content.

Thanks for any help,

David

[djfscouse]

Ok I have it working up to naming the files correctly, at the moment it is naming the files the next rows value in column A.

Hope this makes sense I somebody can help?

Please Login or Register  to view this content.

Thanks anyway,

David

[djfscouse]

Here's the solution just in case anybody needs it! (Highlighted in red)

Please Login or Register  to view this content.