auto fill row with dates

I want to create a column that automatically fills with dates and I want to
insert columns for homework assignments in as well. the problem is getting
it to only place dates that are school days and being able to skip columns
that have the homework assignments in them. If anyone has an idea it would
be appreciated.

It would probably be VERY helpful if you could give us exact for-instances.
Such as, I want to fill column A, C, and D with dates beginning with the 2nd
row, and running for 30 days... something like that.
************
Anne Troy
www.OfficeArticles.com

"tdennis14" <[email protected]> wrote in message
news:[email protected]...
>I want to create a column that automatically fills with dates and I want to
> insert columns for homework assignments in as well. the problem is
> getting
> it to only place dates that are school days and being able to skip columns
> that have the homework assignments in them. If anyone has an idea it
> would
> be appreciated.

I am making a grade sheet where attendance counts toward credit so i want to
have columns with dates that will tell if they were in attendence but on days
that they have homework I need to be able to add columns between the dated
columns . What I would like to do is have a list of the days that are school
days and have excel insert them in order when I tell it to where it tell it
to.

"Anne Troy" wrote:

> It would probably be VERY helpful if you could give us exact for-instances.
> Such as, I want to fill column A, C, and D with dates beginning with the 2nd
> row, and running for 30 days... something like that.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "tdennis14" <[email protected]> wrote in message
> news:[email protected]...
> >I want to create a column that automatically fills with dates and I want to
> > insert columns for homework assignments in as well. the problem is
> > getting
> > it to only place dates that are school days and being able to skip columns
> > that have the homework assignments in them. If anyone has an idea it
> > would
> > be appreciated.
>
>
>

Hi,
You will need a Specific Purpose userform utility for this as your school
days will be different to other schhols and even countries.

You can send me the data and I will create one for you.

you can see my Excel Stuff at
http://www.geocities.com/excelmarksway
[email protected]

- mark

"tdennis14" wrote:

> I want to create a column that automatically fills with dates and I want to
> insert columns for homework assignments in as well. the problem is getting
> it to only place dates that are school days and being able to skip columns
> that have the homework assignments in them. If anyone has an idea it would
> be appreciated.

I would ratherlearn hoowtodoit myself.

"exceluserforeman" wrote:

> Hi,
> You will need a Specific Purpose userform utility for this as your school
> days will be different to other schhols and even countries.
>
> You can send me the data and I will create one for you.
>
> you can see my Excel Stuff at
> http://www.geocities.com/excelmarksway
> [email protected]
>
> - mark
>
> "tdennis14" wrote:
>
> > I want to create a column that automatically fills with dates and I want to
> > insert columns for homework assignments in as well. the problem is getting
> > it to only place dates that are school days and being able to skip columns
> > that have the homework assignments in them. If anyone has an idea it would
> > be appreciated.

Then why did you ask for Help?
Use the visual Basic Help Index in the Visual Basic Editor not the Excel Help.
If you fiind it too complex, you can always come begging to me. I do not
charge any fees and I do not guarantee results.

regards

Mark

"tdennis14" wrote:

> I would ratherlearn hoowtodoit myself.
>
> "exceluserforeman" wrote:
>
> > Hi,
> > You will need a Specific Purpose userform utility for this as your school
> > days will be different to other schhols and even countries.
> >
> > You can send me the data and I will create one for you.
> >
> > you can see my Excel Stuff at
> > http://www.geocities.com/excelmarksway
> > [email protected]
> >
> > - mark
> >
> > "tdennis14" wrote:
> >
> > > I want to create a column that automatically fills with dates and I want to
> > > insert columns for homework assignments in as well. the problem is getting
> > > it to only place dates that are school days and being able to skip columns
> > > that have the homework assignments in them. If anyone has an idea it would
> > > be appreciated.