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)
|