Copying Excel formulas from one Workbook to another
Barb, don't know how to thank you...you saved me hours!!!!!! of work! This
resolution worked like a charm!
--
Deb
"Barb Reinhardt" wrote:
Try doing a find/replace and replacing the workbook name with blank on the
worksheet of interest.
--
HTH,
Barb Reinhardt
"Deb G" wrote:
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
|