Savings excel sheets in csv format....need help

Hi,

I have series of sheets in a workbook and i want the data to export to csv format. can someone help me. the data given is in a template given below. there are around 10 such sheets, if i save as csv format, i get some junk character and the format changes. also csv format doesnt accepts multiple sheet. need help. Also can someone let me know the code to pick up only the entered data from the template below and not the headings. bcoz the headings are not in one row

Entity ID
adasdasdas

Entity (Account) Name
sdfsfsfsd

Submitted by Name
dfsdsfsfsd

Date Entered
2-Jan-13

Corporate Notes
sadasdasdfasdasdas

Almir's picture

Try to change column headings to a single row

Try this first. There are only 10 sheets. It shouldn't take long. Maybe that is the only thing you need to do.