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

"Rosered" wrote in message
...
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

"Rosered" wrote in message
...
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

"Rosered" wrote in message
...
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

"Rosered" wrote in message
...
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?????