Valli,
Thanks for your quick reply!
- Is it possible to set the headers names as Row headers in Excel without any pivot results row etc.
- and also add the Autofilter in Excel?
Since the data that is exported to Excel has all the headers as rows rather than Row Header in Excel, I am not able to add the Autofilter feature in Excel.
Attached Excel file has the data that has data exported thru the Code in the first sheet ("Output from code" sheet) and the data how I would like to have in the second sheet(Output Wanted).
Thanks!!
Sample119.zip