![]() |
I need worksheet with a mnth worth of dts. 1 date a sheet.. HOW?
I need to make a worksheet with a month worth of dates on it... One day for
each tab...is there any easy way to do this??? |
I need worksheet with a mnth worth of dts. 1 date a sheet.. HOW?
The way i would do it is to create a list of dates you want to have as tabs
in a list labled date. Then do a pivot table on that list then put the date in the page of the pivot table Then Click on the pivot table show pages command on the pivot table toolbar. Then select all pages and delete the pivot tables. Some one more expert may have an eiser way but I do this all the time. Brian Bleifeld "LDvorak" wrote: I need to make a worksheet with a month worth of dates on it... One day for each tab...is there any easy way to do this??? |
All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com