Is it possible to copy a worksheet into a separate worksheet so that the copy makes all the changes I make on the original copy? I have a worksheet with several hotels listed - reserved rooms/ daily count / rooms remaining / percentages taken and remaining. Each one is different. I need to send each chart to the appropriate hotel, but I don't want to send the entire worksheet. I would like to create separate worksheets for each hotel from the main page. Is there any way to do that so that as calculations change on the main page, they will also change on the copied page? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Worksheet complete duplication
- Thread starter Bmsteach8
- Start date
Similar threads
- Solved
