Ummmm,
b1 to h1 contains the seven days on a week
a2 contains a date like whatever day Sunday is
highlight a2 and drag your mouse down 100 some cells
Click on Edit - Fill - Series - click on date and enter a step value of 7
then click okay
place the persons name our knickname when they work
Click on File - Page Setup - Sheet - Rows to repeat at top enter
$1:$1
then click Okay.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
