automatic copy of results to another page

G

Guest

I am creating a yearly expense sheet with per month each page and a summary
sheet with monthly totals
How can I set it up so when results for monthly totals are created on the
month page they also appear on the yearly summary page?
 
D

Don Guillett

One way of many
=sheet2!a2
where a2 in sheet 2 has the total for the month.
 

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

Automatic copying of results from one sheet to another on same fil 1
Formula question 2
Combine information from two pages, two changing locations. 6
How can I copy column sums to another spreadsheets as numbers 3
IN EXCEL...I CANNOT COPY THE TOTAL LINE AND PASTE IT ...I GET REF. 1
Referencing a named range on another sheet 4
link 1 sheet to another(totals) 1
summaries on alternative sheets 6

Top