In addition to the above I dont have option to create the temporary tables in the client servers.

HI,

Actually there is some formatting and formulae are existing at the detsination sheet Where I am interested to paste teh data.. Sorry I miss this point. I am looking at...

Hi I guess people are not getting what I mean to say.

Actually I am having a report in one of the tab of excel sheet. For this report I need...