Copy sheet to other workbook

**imran91** · 09-06-2012, 04:58 AM

Hi guys

The title sounds easy in fact, i actually can do it. But here is the real situation that i can't do it, I have two workbooks: A and B. I want to make a code that makes sheet3 in wbA stored in wbB. And, if i make changes to data in sheet3, i can stored the new sheet3's data in new sheet in wbB. For instance, the 1st sheet3 will be stored in wbB as the 1st sheet. Then the 2nd sheet3 (modified data) will be stored in wbB as the 2nd sheet. So, thats mean wbB automatically add a new sheet.

Here is a code that i try to do, but since i'm noob in vba, i'm fail.

Please Login or Register  to view this content.

Is it clear? because i found it hard to explains. If anyone know how to do it, please help me.

Thanks

**arlu1201** · 09-06-2012, 07:32 AM

You say that you are updating sheet3 twice (as in the example), so how will the macro identify which is the updated data v/s the original data?

Will the original data be cleared out and then the updated data filled in?

**imran91** · 09-06-2012, 08:50 PM

Yes. something like that. Actually, the sheet3 contain invoice. So i want to save the invoice into wbB as sheet1 and then it will cleared out. And whenever the invoice updated again, i want to save it into wbB as sheet2, and if the invoice updated again, it will be saved as sheet3 in wbB.

**imran91** · 09-07-2012, 12:22 AM

I found this code somewhere in internet and i change a bit and it really works.

Please Login or Register  to view this content.

But, the sheet will be saved in wkbDest as INVOICE, INVOICE (2), INVOICE (3) and so on. what i want is that the name of the sheet will be Sheet1, Sheet2, Sheet3 and so on. Does anyone know how to change the code because i have try to change it, but nothing happen.