You are reading a single comment by @rhb and its replies. Click here to read the full conversation.
  • No that I've found, my workaround is to use a hidden config sheet with file paths/etc. There's probably a better way!

    If you're just copying sheets, then no I don't think macros copy as well - you either need to save the whole workbook as a copy or copy individual macros across. Obvs make sure it's .xlsm to keep the macros!

  • I was approaching it wrong... in the end all I had to do was make a copy of the macros & pivots workbook and copy the other worksheets (no macros or pivots) across into that.

    Will be trickier if ever there's macros in both workbooks, i found a tip to export & import these in this case.

About

Avatar for rhb @rhb started