Multiple Worksheet in Excell Workbook
I have a workbook with multiple worksheets. Each worksheet is dated with a
column of dates based on a two week work period. The dates within each worksheet need to reflect that weeks work dates. How do I key the dates to each worksheet without having to physically key dates to each worksheet? ex.: Date Arrival Time Departure Time November 01 10am 2pm November 02 10am 2pm |
Multiple Worksheet in Excell Workbook
Hi
Is everyday considered a workday or do you only count M-F? How do you decide the start date of the first worksheet? Where do you put the dates - what cell for the first one and are all the others immediately below that? Are all spreadsheet set up identically? Is the first day on a new sheet one day later than the last day on the previous sheet? Thanks, Shane Devenshire "RMoore" wrote: I have a workbook with multiple worksheets. Each worksheet is dated with a column of dates based on a two week work period. The dates within each worksheet need to reflect that weeks work dates. How do I key the dates to each worksheet without having to physically key dates to each worksheet? ex.: Date Arrival Time Departure Time November 01 10am 2pm November 02 10am 2pm |
All times are GMT +1. The time now is 09:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com