I have a Excel 2010 workbook with a range of worksheets named Tracking, CO 001 Start, CO-Simple, CO-Breakdown, CO-Worksheet & CO 001 End. The tracking worksheet contains a table where cells A5:A20 are user entries. What I would like is when a user enters a new entry in one of these cells (A5:A20) that the range of worksheets CO 001 Start, CO-Simple, CO-Breakdown, CO-Worksheet & CO 001 End is copied and placed at the end of the worksheet tabs.
If it's also possible to have the CO start and CO end sheets renamed to the user entry (i.e. CO 8123-002 Start) that would be very helpful.
Is it also possible to clear specific cells only when the new sheets are copied?
I've attached the workbook as well for reference.
Thanks in advance for helping out.
Bookmarks