Help - Need macro to create a CSV file from a worksheet with different formatting
I've done a little C++, but am new to VBA.* Users need a button (or other easy method) that will copy rows from their worksheet into a new CSV file with a few changes.* The number of rows can vary, as well as the filename.* And is there an easy way for users to get this functionality?* I've attached an example of the original file and what the new CSV should look like (had to upload CSV as Excel).
Table 1 (original workbook is Excel 2003)
Project Number ERP Ref No. Project Name
B004 5555 BB Jackson Project
B005 abc123 BB Date Demo Project
Table 2* (new CSV):* Some notes at the top, then a "D" in the first new column, and then "Standard" in the next new column for each record)*
~~Notes for user in top few rows.
~~~Notes for user in top few rows.
~Notes for user in top few rows.
D Tab Name Project Number ERP Reference Number Project Name
D Standard B004 5555 Jackson Project
D Standard B005 abc123 Date Demo Project
Bookmarks