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
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.