I am trying to add a sheet with formulas referencing cells in other sheets within the same workbook. I have however emailed out this workbook for someone to enter data, so I am creating the new worksheet in a duplicate copy of the original workbook. Would it be possible to copy this new sheet to the original workbook if all other sheets remain untouched?
So to complete the subject line above, I am trying to :
Copy sheetA from workbook2 (WB2) to workbook1 (WB1) where WB2 is a duplicate copy of WB1 except that sheetA was added to WB2, and has formulas referring to other sheets within the workbook.