Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello...would like to create a daily logbook for our maintenance dept.....is
there a way to print a daily worksheet so each would display the date (one sheet for each day during the year)? The dates need to be pre-printed on each sheet to conform to regulations. Any one's ideas or suggestions are GREATLY appreciated. JoEllen L. |
#2
![]() |
|||
|
|||
![]()
Just a suggestion...
I'd use one worksheet for all the data. Use one column for the Date (column A???). Then apply Data|filter|Autofilter to the whole range. You can filter it by any date you want--and even by employee/project or any other data you have in that worksheet. When the data is in one spot, there's lots of nice things you can do with it. Putting the data on multiple worksheets makes summaries more difficult. JoEllen wrote: Hello...would like to create a daily logbook for our maintenance dept.....is there a way to print a daily worksheet so each would display the date (one sheet for each day during the year)? The dates need to be pre-printed on each sheet to conform to regulations. Any one's ideas or suggestions are GREATLY appreciated. JoEllen L. -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Thanks for the quick response! Let me add that what I need to do is create an
entire year's worth of sheets (with the date preprinted on each), print them and have it bound into a book (the state doesn't want anyone fiddling with the data I guess). Still up for any suggestions, and thanks again in advance........ "Dave Peterson" wrote: Just a suggestion... I'd use one worksheet for all the data. Use one column for the Date (column A???). Then apply Data|filter|Autofilter to the whole range. You can filter it by any date you want--and even by employee/project or any other data you have in that worksheet. When the data is in one spot, there's lots of nice things you can do with it. Putting the data on multiple worksheets makes summaries more difficult. JoEllen wrote: Hello...would like to create a daily logbook for our maintenance dept.....is there a way to print a daily worksheet so each would display the date (one sheet for each day during the year)? The dates need to be pre-printed on each sheet to conform to regulations. Any one's ideas or suggestions are GREATLY appreciated. JoEllen L. -- Dave Peterson |
#4
![]() |
|||
|
|||
![]()
If you create a single sheet laid out nicely, you could have a macro that would
print that sheet (after changing the cell containing the date) multiple times. Do you need to keep the worksheet, too? And if you post the location of the date (A1 or B9 or ????), you'll get a few more responses. JoEllen wrote: Thanks for the quick response! Let me add that what I need to do is create an entire year's worth of sheets (with the date preprinted on each), print them and have it bound into a book (the state doesn't want anyone fiddling with the data I guess). Still up for any suggestions, and thanks again in advance........ "Dave Peterson" wrote: Just a suggestion... I'd use one worksheet for all the data. Use one column for the Date (column A???). Then apply Data|filter|Autofilter to the whole range. You can filter it by any date you want--and even by employee/project or any other data you have in that worksheet. When the data is in one spot, there's lots of nice things you can do with it. Putting the data on multiple worksheets makes summaries more difficult. JoEllen wrote: Hello...would like to create a daily logbook for our maintenance dept.....is there a way to print a daily worksheet so each would display the date (one sheet for each day during the year)? The dates need to be pre-printed on each sheet to conform to regulations. Any one's ideas or suggestions are GREATLY appreciated. JoEllen L. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create an hourly daily planner? | New Users to Excel | |||
Trying to create a Sales Projection/Forecast/Estimate | Excel Discussion (Misc queries) | |||
Template in Excel | New Users to Excel | |||
how do i create a daily income report (i'm a waitress) | New Users to Excel | |||
How do I create a daily spending spreadsheet in Excell? | Excel Worksheet Functions |