copy to new workbook

  1. R

    Overwrite existing files and save as PDF XLSM and new sheet

    Hi I have this save button, that saves: 3 sheets into pdf 4 sheets into a new workbook (xlsm) 1 sheet into a new copy inside the workbook My problem is if i want to save the sheets again it dosn't overwrite the old one. So my question is how to change the code so it overwrite existing files...
  2. A

    Use Input boxes to pick existing workbook and existing sheets in the workbook

    Hi Guys, I have some code that copies some columns of data based on the text typed into an input box. Code below is working great. What I would like to achieve if possible is 2 more input boxes asking for the destination workbook name and also the sheet name within the destination workbook...

Some videos you may like

This Week's Hot Topics