Reply to thread

Message: [QUOTE="Deb G, post: 11810808"] I have a workbook that has 13 worksheets. One for each month and then one for a tally of all worksheets to get quarterly and ytd totals. I created 5 of these for 5 different depts A user corrupted the 13th summary page in one dept. I want to copy the 13th summary page from one dept (one workbook) to the other dept (second workbook). Every time I copy and paste, it also pastes the location of the first workbook. I do not want to copy the workbook location, I just want to copy the formulas. If I try paste special to get the formulas only, it still copies in the the first workbook location. Is there a way to copy and paste formulas from one workbook to another without the original workbook location also copying? Thank You! Deb [/QUOTE]