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
|
Similar Threads
