Excel for work hours

[DC_FC]

I use excel to keep track of what hours i do at work but is there an easier to copy/transpose all the dates etc from 1 sheet to another ? At the minute i just type out the days and do the calculations.

[HowardKennitby]

If the dates are all in one column then select the entire column then cut and paste to the new sheet.

[craft1948]

If you type in the first couple of dates, highlight the cells then drag down from the bottom left-hand corner it will infill the calendar dates for you.........

[HowardKennitby]

Just in case I have misunderstood can you describe the layout of the sheet in more detail.

[craft1948]

Sorry bottom right -hand corner........

[DC_FC]

The way i have it set up is that each sheet in excel is for each month and i have the dates for example monday to saturday for week 1 in row 1 then week 2 in row 6 etc etc.

[venator]

type 1 in Cell A1

Type Mon, Tues or whatever the first day is into Cell B1

Select them both and click on the black square in bottom right.

Still holding the mouse on the square, drag down for 31 or whatever number of days there are in the month.

Sorry if this is a bit simplistic, but your problem isn't very advanced stuff..

[DC_FC]

Thanks for your replies, venator your solution was what i was kind of after except i have a row for each week but ill give your solution a go