Hi
I have a created a model and have a worksheet for the output statistics. What I'm trying to do is change some parameters in the model and then copy the output stat. worksheet into a new workbook. This I can do, copy worksheet, put into a new workbook. However, I would like it so the values remain, it seems when I change something in the parameters of the original workbook that my copied sheet in the new workbook also changes. I would like it so it copys the page and the values don't change when I put it into the new workbook.
Ex. Original Workbook: Output stat page
Copy Output stat page: into New Workbook
Change original workbook parameters....but have it so the "output stat page" in the NEW workbook does NOT change.
Sorry, if this is too long and confusing. Any help you could provide on solving this problem would be greatly appreciated.
Thanks, have a great day.
I have a created a model and have a worksheet for the output statistics. What I'm trying to do is change some parameters in the model and then copy the output stat. worksheet into a new workbook. This I can do, copy worksheet, put into a new workbook. However, I would like it so the values remain, it seems when I change something in the parameters of the original workbook that my copied sheet in the new workbook also changes. I would like it so it copys the page and the values don't change when I put it into the new workbook.
Ex. Original Workbook: Output stat page
Copy Output stat page: into New Workbook
Change original workbook parameters....but have it so the "output stat page" in the NEW workbook does NOT change.
Sorry, if this is too long and confusing. Any help you could provide on solving this problem would be greatly appreciated.
Thanks, have a great day.