Hello,

i need to export an excel sheet to a txt file (which will be imported
by another apllication) using VBA.

The data in excel sheet is organized like this:

Account Jan Feb Mar ....
256 5 7 3
248 3 1 9
.....

I would like to export the data like this:

Account Month Amount
256 1 5
256 1 7
256 1 3
248 2 3
248 2 1
.........

Can someone give me a hint on how to do this?

thanks very much