empty
Split Sheet By Date command lets you split a sheet into separate sheets based on the value of a date column.
You can split the sheet by year, month, day, day of week or week number of the year.
Splitting Worksheets
Example
You can split the sheet by year, month, day, day of week or week number of the year.
Splitting Worksheets
Example
- Open ActiveData's Sample Workbook
- Select the Invoices Sheet
- Select Split Sheet By Date from the ActiveData Menu
- In the Split Sheet By Date dialog box, select the period of time you wish to isolate: either day, week, day of week, month, or year. For this example select Month.
- Click Finished.
