Need Help Automating Consecutive Date listings

  • Thread starter Thread starter Moustaffa bin al-Erickson
  • Start date Start date
M

Moustaffa bin al-Erickson

Hello,

I need to prepare a worksheet that will have 12 pages (1 for each month) in
2004. It will have a column listing every day of the month in a 1/1/2004
format. I will be manually entering data into these rows as the dates occur.
Is there an easier, quicker way to enter all the dates in a month in this
manner (rather than manually entering them)?

I've looked in the functions section of help for Excel 2000 and can't find
anything that would appear to work for me.

Thanks
 
Just type your 1/1/2004 in the top cell in your column, say it's A1, then
just put the mouse cursor over the little black square in the lower right
hand corner of the cell and press the left mouse button and hold it down,
and drag the cursor down the column as far as you want and when you let go,
all the dates will be filled in automatically......if you went too far, just
erase the ones you don't want........

Vaya con Dios,
Chuck, CABGx3
 
Moustaffa

Before you begin with Chuck's suggestion, which is correct, if that's what you
want. Note: you will have to do this on each of 12 sheets one month at a
time.

Are all months essentially going to be for entering similar data on a
month-by-month basis?

Will you be doing Totals and Sub-totals across those months?

You may run into fewer problems later if you enter a full year on one sheet
then use the features that Excel provides for Summing, Sub-totalling,
filtering, hiding un-used rows and many more.

You can always break out each month later into single sheets if desired or
leave it all on one sheet and use Views and Reports to summarise and print
out.

Just a few thoughts.

Gord Dibben XL2002
 
Good points Gord, that helps me too........I have a friend who wants a
historical database of WorkOrders done similar to what the OP has described,
but with "automatic" month summing, etc.......I'll recommend your
suggestions .........thanks

Vaya con Dios,
Chuck, CABGx3


Gord Dibben said:
Moustaffa

Before you begin with Chuck's suggestion, which is correct, if that's what you
want. Note: you will have to do this on each of 12 sheets one month at a
time.

Are all months essentially going to be for entering similar data on a
month-by-month basis?

Will you be doing Totals and Sub-totals across those months?

You may run into fewer problems later if you enter a full year on one sheet
then use the features that Excel provides for Summing, Sub-totalling,
filtering, hiding un-used rows and many more.

You can always break out each month later into single sheets if desired or
leave it all on one sheet and use Views and Reports to summarise and print
out.

Just a few thoughts.

Gord Dibben XL2002
Click to expand...
 
Back
Top