Hi Guys,

I need to take an extract from SQL Server table and populate the data in a no of excel sheets. I generally copy paste it and do some manually formatting. The formatting is same for all the sheets. Can somebody let me know the steps involved if I want to automate the process with the help of macro?

A detail description would be appreciated.

Thanks in advance
Prasan