Automatic Formula Add
 

I would like to have some formulas added to the end of a worksheet when the
user enters a new row of data. How can I implement this?

Example:
Column A contains a date
Column B contains the Weekday Function

A B
1 12/1/2006 =Weekday(A1) Display value in B1 is 6
2 12/2/2006 =Weekday(A2) Display value in B2 is 7


When the user adds a new date to row 3, I would like Column B to
automatically contain =Weekday(A3) without having to use copy and paste.

Any help is appreciated very much.
--
rgb

Automatic Formula Add
 

Click on Tools, Options, Select the Edit tab, make sure that the option to
extend Formats and Formulas is ticked, and it will work, that is, if you type
in the dates. If you use a calender add in, it does not extend. What you
can do then is to move to where you want the formula pasted, and press
<Ctrl<D to copy the formula down. Iow, if your last row is A4:B4, and you
now insert a date in A5, then go to B5, and press <Ctrl<D

"rgb" wrote:

I would like to have some formulas added to the end of a worksheet when the
user enters a new row of data. How can I implement this?

Example:
Column A contains a date
Column B contains the Weekday Function

A B
1 12/1/2006 =Weekday(A1) Display value in B1 is 6
2 12/2/2006 =Weekday(A2) Display value in B2 is 7


When the user adds a new date to row 3, I would like Column B to
automatically contain =Weekday(A3) without having to use copy and paste.

Any help is appreciated very much.
--
rgb

Automatic Formula Add
 

Kassie,

Thanks for the reply. The options are checked correctly, and I am not using
the calender add in. The strange thing is that I have formulas in 13
comlumns and only 2 of the comlumns carry down when I enter a new date. I
think I will start a new worksheet and try to figure it out. Thanks for the
reply, it told me what I need to know about the automatic copy.
--
rgb


"kassie" wrote:

Click on Tools, Options, Select the Edit tab, make sure that the option to
extend Formats and Formulas is ticked, and it will work, that is, if you type
in the dates. If you use a calender add in, it does not extend. What you
can do then is to move to where you want the formula pasted, and press
<Ctrl<D to copy the formula down. Iow, if your last row is A4:B4, and you
now insert a date in A5, then go to B5, and press <Ctrl<D

"rgb" wrote:

I would like to have some formulas added to the end of a worksheet when the
user enters a new row of data. How can I implement this?

Example:
Column A contains a date
Column B contains the Weekday Function

A B
1 12/1/2006 =Weekday(A1) Display value in B1 is 6
2 12/2/2006 =Weekday(A2) Display value in B2 is 7


When the user adds a new date to row 3, I would like Column B to
automatically contain =Weekday(A3) without having to use copy and paste.

Any help is appreciated very much.
--
rgb

Automatic Formula Add
 

In between those 13 columns, are there by chance an empty column?

"rgb" wrote:

Kassie,

Thanks for the reply. The options are checked correctly, and I am not using
the calender add in. The strange thing is that I have formulas in 13
comlumns and only 2 of the comlumns carry down when I enter a new date. I
think I will start a new worksheet and try to figure it out. Thanks for the
reply, it told me what I need to know about the automatic copy.
--
rgb


"kassie" wrote:

Click on Tools, Options, Select the Edit tab, make sure that the option to
extend Formats and Formulas is ticked, and it will work, that is, if you type
in the dates. If you use a calender add in, it does not extend. What you
can do then is to move to where you want the formula pasted, and press
<Ctrl<D to copy the formula down. Iow, if your last row is A4:B4, and you
now insert a date in A5, then go to B5, and press <Ctrl<D

"rgb" wrote:

I would like to have some formulas added to the end of a worksheet when the
user enters a new row of data. How can I implement this?

Example:
Column A contains a date
Column B contains the Weekday Function

A B
1 12/1/2006 =Weekday(A1) Display value in B1 is 6
2 12/2/2006 =Weekday(A2) Display value in B2 is 7


When the user adds a new date to row 3, I would like Column B to
automatically contain =Weekday(A3) without having to use copy and paste.

Any help is appreciated very much.
--
rgb

Automatic Formula Add
 

No empty Columns, but I have figured out most of it. Problem seems to come
from using the SUM Funstion. When I have something like =SUM(A1:A5) it does
not copy the foemula down. It seems to be the : in the sum function. If I
use a coma it copies down but of cource I don't get the correct value. I
have tried using SUM(OFFSET(A5,-5,0):A5) but that doesn't copy down either.
I must be missing something with the :. Again, thanks for your help. I am
on the right track.
--
rgb


"kassie" wrote:

In between those 13 columns, are there by chance an empty column?

"rgb" wrote:

Kassie,

Thanks for the reply. The options are checked correctly, and I am not using
the calender add in. The strange thing is that I have formulas in 13
comlumns and only 2 of the comlumns carry down when I enter a new date. I
think I will start a new worksheet and try to figure it out. Thanks for the
reply, it told me what I need to know about the automatic copy.
--
rgb


"kassie" wrote:

Click on Tools, Options, Select the Edit tab, make sure that the option to
extend Formats and Formulas is ticked, and it will work, that is, if you type
in the dates. If you use a calender add in, it does not extend. What you
can do then is to move to where you want the formula pasted, and press
<Ctrl<D to copy the formula down. Iow, if your last row is A4:B4, and you
now insert a date in A5, then go to B5, and press <Ctrl<D

"rgb" wrote:

I would like to have some formulas added to the end of a worksheet when the
user enters a new row of data. How can I implement this?

Example:
Column A contains a date
Column B contains the Weekday Function

A B
1 12/1/2006 =Weekday(A1) Display value in B1 is 6
2 12/2/2006 =Weekday(A2) Display value in B2 is 7


When the user adds a new date to row 3, I would like Column B to
automatically contain =Weekday(A3) without having to use copy and paste.

Any help is appreciated very much.
--
rgb