Creating Worksheet Templates
This video shows that if you need a worksheet for each state set up in an identical format, how to easily use worksheet templates to set up the 50 needed worksheets.
If you like this video and would like to enroll in my FREE 21 day course, you can do so by visiting this link:
Data Engineer, Healthcare Pricing
5 年The tab grouping feature is great. For users open to Excel+Python, the open source xlwings package has been a huge timesaver for worksheet templates. You can loop through tabs that share the same structure for edits that may be less natural in Excel. E.g., say we have an all-state data set and we want state-specific data to appear in a corresponding “state” tab. Python xlwings with pandas makes generating these state-level data sets easy. I think Excel 2019 filter() partly supports this now if your org has updated.