Code for addition

  • Thread starter Thread starter Chance
  • Start date Start date
C

Chance

I have a daily ticket that uses a macro to copy and paste
a blank report at the end of the work book. Each ticket
has a daily total and then a box for the job total. The
job total is the total of all the tickets in the work
book. Is there a code that can be written so the new
ticket will add the total from the last ticket & the daily
total and show the answer in the Job total cell?

Thanks,
Chance
 
Chance

You can sum across sheets. Assume your first sheet in the workbook is named
Blank. The next sheets are named Ticket1, Ticket2, Ticket3, etc.. You can
use a formula like this on Ticket3

=SUM(Ticket1:Ticket2!F10) + F9

assuming your job totals are in F10 and your daily totals in F9.
 
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

Tally operations question 1
Saving worksheets to new workbook 3
Powerpoint calculation VB 0
Need Help soon with this querry!!!!!! PLZ PLZ 0
group/sum in ms query 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Populating one field first, rest later 2
How can I calc totals for specifc techs on a specific date? 3

Back
Top