sir i have a active workbook by name "full2011" which will be open
and in that one sheet by name "pastenew"
now i want to copy data from that sheet starting from third entire row to the end row data

in one workbook by name "data2011" the file is on desktop
in the sheet name "full" with first empty row in that sheet
save the workbook "data2011" and close

and again paste that data to one more workbook by name "complete2011"
in the sheet name "data" with first empty row and then save and close

and now clear data from active workbook starting entire third row to the last row

any doubt reply
thank you in advance

harish