Copy worksheet from a closed workbook to active workbook with conditions

  • Hi All,

    Anyone here can help on a VBA script to copy 1st and 2nd sheet from a closed workbook to currently opened workbook overwriting and contents of sheet 2 and 3?

    The 1st and 2nd sheet names of the closed workbook changes dynamically so please don't rely on the sheet1 and sheet2 names.

    The 1st sheet of current opened workbook that will be copied onto is static and contains all the formulas and calculations based from sheets 2 and 3 on the same opened workbook. The sheets 2 and 3 contains the contents from sheet 1 and 2 from the closed workbook.

    Appreciate your help in advance.


    EDIT: cross posting it also here to get a solution >>…ntly-opened-workbook.html

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!