with Excel 2011 I copied the section of the sheet I wanted to move, opened another workbook, and then pasted it where I wanted it but none of the formulas in the cells transfered. Is there a way to do this with this older version of Excel?
[doublepost=1496366813][/doublepost]I found my error. I needed to unprotect the workbooks first. Now I can do it after right clicking on the sheet tab and choosing "move or copy".
[doublepost=1496366813][/doublepost]I found my error. I needed to unprotect the workbooks first. Now I can do it after right clicking on the sheet tab and choosing "move or copy".