Macro for journal entry

[skhan1]

Hi guys,

I am new to VBA. I am trying to create a macro that generates a CSV file (Journal Entry for Accruals). The format of the CSV file, I want the macro to generate, is in the Excel sheet attached. Basically, first sheet contains the data and the second sheet is the format of the JE.

Could you kindly help me with this?

And is it possible, when I run the macro, it asks me for the month-end date (like in spreadsheet it is June 30).?