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
Bookmarks