Here LaDonna, you can play with this.
passwords for LaDonna - closed.xlsm
passwords: bs123, rd123, bb123, bw123, lr123, & admin
Each password opens up a different part of the workbook.
- the Summary tab shows the rollup, with a date range that can be set to selectively pull records
- the List tab shows the dropdown options
- the Passwords tab shows who has access to what and with what password; you can change the passwords in column A
- the Front tab is the landing zone that everyone hits first
- only the Admin password has access to everything
Bookmarks