G
Guest
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.
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.