How to copy sheet from one workbook to another?
Posted: Tue May 31, 2011 3:57 pm
Hi,
I checked this forum for copy sheet functions. It seemed that Lars said he will have the function of copy sheets from one workbook to another ready in the next release in 2009. I am wondering if that version is ready now.
if it not ready, what will be the best way to get the sheet data from one workbook to another? Looping through one sheet and assigning all data to the other sheet in a different workbook?
It is appreciated if someone can help!
Gene.
I checked this forum for copy sheet functions. It seemed that Lars said he will have the function of copy sheets from one workbook to another ready in the next release in 2009. I am wondering if that version is ready now.
if it not ready, what will be the best way to get the sheet data from one workbook to another? Looping through one sheet and assigning all data to the other sheet in a different workbook?
It is appreciated if someone can help!
Gene.