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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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!!!
 
Use a worksheet_change event to
target.offset(,1)=target(offset(-1)+target
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting integer to varchar and vice versa (Newbie) 2
Excel challenge, please save a doctor some time! 1
Excel Vba to change displayed year automatically. 14
Add one year in second combobox in vba 0
How to enter excel dates for last year? 10
Remove date format? 3
Year to date totals 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top