KK1966
08-19-2008, 07:18 AM
Hi
I need help with copying and pasting, actually can excel to open another file copying? and paste at the my active WS? if possible can u help me the code as I needs found the historical data "sheet name are same and the COLUMN also same, but the Rows are an unknow? I think i needs to open about 110 to 120 workboos so, brothers please advise me if excel can automatically to count by rows to copy and paste count by last row, so
-copy the open file at the sheet1 range A1 to A?
paste in to active excel count by COL A last row
Billion thank
I need help with copying and pasting, actually can excel to open another file copying? and paste at the my active WS? if possible can u help me the code as I needs found the historical data "sheet name are same and the COLUMN also same, but the Rows are an unknow? I think i needs to open about 110 to 120 workboos so, brothers please advise me if excel can automatically to count by rows to copy and paste count by last row, so
-copy the open file at the sheet1 range A1 to A?
paste in to active excel count by COL A last row
Billion thank