Re: Copy Data Range From 1 Workbook To Another
I've tested your new files and it worked. Many thanks Xlite.
But the issue to me that is I've got one macro to edit the raw sheet to clean one after I bring all raw sheets(Sheet2 in this case) orginally to one sheet.
That means I need to edit all of them one by one first and apply your code later to bring all reparate sheets to test.xls later. If that is the case, I must edit one by one manually before apply your code.
Do you have any other way to do the same as current code but bring original Sheet2 content to Test.xls?
I understand that the Good House Keeping will help but I can't avoid that b/c the resources file are big and a lot. Sorry I ask you again.