EXCEL-how to add rowA to year to date rowB??

I am keeping a spreadsheet to which i change the first column $s monthly. I
want to have the sheet auto add the new month's $s to the second column year
to date. HOW TO DO?????

Do you mean that you want to take all info in col A and append to the next
available cell in col B?

--
Don Guillett
SalesAid Software
donaldb@281.com
"Rosered" <Rosered@discussions.microsoft.com> wrote in message
news:98F23B0E-6B4D-44E4-BF56-F1916B0B14C8@microsoft.com...
> I am keeping a spreadsheet to which i change the first column $s monthly.
I
> want to have the sheet auto add the new month's $s to the second column
year
> to date. HOW TO DO?????

hi don - thank you for your reply. I keep a s/sheet with monthly $s in col
a. when i post the new monthly $s in col a I want col b to auto add those $s
to the previous months $s. this will give me a year to date total $s amount.
how can i do this?? thanks so much!!!

"Don Guillett" wrote:

> Do you mean that you want to take all info in col A and append to the next
> available cell in col B?
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Rosered" <Rosered@discussions.microsoft.com> wrote in message
> news:98F23B0E-6B4D-44E4-BF56-F1916B0B14C8@microsoft.com...
> > I am keeping a spreadsheet to which i change the first column $s monthly.
> I
> > want to have the sheet auto add the new month's $s to the second column
> year
> > to date. HOW TO DO?????
>
>
>

Use a worksheet_change event to
target.offset(,1)=target(offset(-1)+target


--
Don Guillett
SalesAid Software
donaldb@281.com
"Rosered" <Rosered@discussions.microsoft.com> wrote in message
news:BABA6229-2F20-48CA-B183-B4D6848B2245@microsoft.com...
> hi don - thank you for your reply. I keep a s/sheet with monthly $s in
col
> a. when i post the new monthly $s in col a I want col b to auto add those
$s
> to the previous months $s. this will give me a year to date total $s
amount.
> how can i do this?? thanks so much!!!
>
> "Don Guillett" wrote:
>
> > Do you mean that you want to take all info in col A and append to the
next
> > available cell in col B?
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "Rosered" <Rosered@discussions.microsoft.com> wrote in message
> > news:98F23B0E-6B4D-44E4-BF56-F1916B0B14C8@microsoft.com...
> > > I am keeping a spreadsheet to which i change the first column $s
monthly.
> > I
> > > want to have the sheet auto add the new month's $s to the second
column
> > year
> > > to date. HOW TO DO?????
> >
> >
> >