Is it possible for a workbook to automatically take all the sheets in that workbook and copy then to another sheet every time the book opens? So as I add new sheets to the book and re-open it the recap sheet would have all the data on it already?
-
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.
Yongle
Well-known Member
- Joined
- Mar 11, 2015
- Messages
- 6,977
- Office Version
- 365
- Platform
- Windows
1. What does copy mean?
- copy & paste values, retain formulas ???
2. Why are you regularly adding new sheets? Are they daily sheets or something else?
3. When copying to Recap should the original sheet name be inserted against each value?
4. What happens to the original sheets after copying to "Recap"
- are they deleted?
(ie should the workbook effectively always open with only one sheet "Recap")
- copy & paste values, retain formulas ???
2. Why are you regularly adding new sheets? Are they daily sheets or something else?
3. When copying to Recap should the original sheet name be inserted against each value?
4. What happens to the original sheets after copying to "Recap"
- are they deleted?
(ie should the workbook effectively always open with only one sheet "Recap")
Upvote
0
Similar threads
- Question
