Adding numbers continously in multiple cells

  • Thread starter Thread starter KMF
  • Start date Start date
K

KMF

Thanks, is it possible to use the formula below in more
than one cell? I would like to add several items in
different cells on one worksheet and have them added
(accumulated) in designated cells in another worksheet.
 
Thanks, is it possible to use the formula below in more
than one cell? I would like to add several items in
different cells on one worksheet and have them added
(accumulated) in designated cells in another worksheet.
Click to expand...

Yes, just add more "If target.address = "" then - end if" blocks before the
end sub.
 
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

move a row of data from one work sheet to another using a formula 1
Excel VBA 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
how do i copy the result of a formula into another worksheet as te 3
refresh? 2
Summing over multiple worksheets 1
Adding multiple numbers in one cell 16
resettable, over-ridable, default cell values 0

Back
Top