Copy & Paste Values, then export to CSV file

Please Login or Register  to view this content.

Hi, the code above works fine, but I need to adapt it to suit my needs.


First of all, I need to copy I3:lastmemberinI3, L3:lastmemberinI3, X3:lastmemberinX3 (they will all have the same amount of rows from each column).

I then need to paste the values only into the new workbook (which will be used to save as a csv file).

The CSV file needs to be saved as the same name as the spreadsheet the data was first copied from.

Thanks in advance!

Hi,

does this work?

Please Login or Register  to view this content.

Oh sorry, I forgot that. You mean the worksheet name or the workbook name? Choose it in the code!

Please Login or Register  to view this content.

Thank you, the naming convention worked excellent!

I still have the problem of the blank fields (I edited my last post so I'm unsure if you saw it), so the csv file reads something like this(example data)
row1,row2,row3
row1,row2,row3
row1,row2,row3
,,
,,
,,
,,

As I said, I'm sure its becuase of the forumlas in the cells, even though it isnt displaying any data, are you able to help me with

Here's the modified macro, I hope it works.

Please Login or Register  to view this content.

ps. I'm off soon so expect a reply tomorrow.

This worked perfect. Thank you very much for the help.