ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert Duplicate Sheet From Closed Workbook (https://www.excelbanter.com/excel-programming/373134-insert-duplicate-sheet-closed-workbook.html)

Benz

Insert Duplicate Sheet From Closed Workbook
 
I'm hoping someone can help me........... <1st part< I want to be able to
open a workbook trigger a macro that will copy a spcific sheet titled "Tasks"
in its entirity and open it in another workbook (located in the same folder)
where I can change and save it.

<2nd Part<
Is it possible to have another macro that will allow the user to save that
single sheet to a specific workbook overwriting the original and then saving
that workbook.

I've been trying all these difference "cell reference" type codes but
nothing is quite working right. I appreciate any help (ThankYou in advance)


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com