Creating a new CSV file from an existing template or worksheet

Hello Excel mates,

I require some help from you wizards on creating a CSV file with a hit of button. Essentially this CSV file will be used to import the data into some accounting software.

Basically, I have a workbook that contains thousands of rows of data. I have attached a sample of a worksheet with very few lines with fake data but essentially the structure is the same. This data exists in the tab named "Input". Some of the rows are blank in my real sheet and don't contain any records.

This worksheet is continually growing and the rows sometimes vary - but generally there are about 5000 rows. The columns do not change very often but in the future it is possible that I may add or delete columns.

I seek some help in arranging the data to a layout that is similar to the layout in the "Output" tab. However, with your help, I hope to create the output in a new CSV workbook not a new worksheet that is created within the current/existing workbook.

In addition to creating a new CSV file, I need some help in converting all accounts that are "revenues" or end with a suffix code of 4000 series to negative numbers or credit balances. The output tab indicates this. My guess is that the macro would need to count up to the last row of data and exclude any rows with blank information and then copy and paste it into a new CSV file.

Any help would be greatly and sincerely appreciated!!