I've created a series of identical spread sheets to calculate customer traffic vs. sales through my shop. The individual sheets are all working fine with lots of regular formula's including AutoSum and regular adding and dividing.

At the bottom of each monthly sheet is a line of figures created using formulas and autosum. I want to copy these figures automatically only a yearly sheet showing the monthly line of figures. And I need them to update themselves automatically if I update an individual month.

Many years ago I could do this - I seems to remember using the $ sign but I can't figure it out now.

Any thoughts clever people

What version of office are you using?

Enter an equal-sign (=) into the target cell on the "yearly"-sheet, then point to the source cell on the monthly sheet, end with "enter". This creates the cell reference automatically. Repeat for each cell/month or use the syntax created to reference the other cells...

quote:

---

Originally posted by Lippoman
Enter an equal-sign (=) into the target cell on the "yearly"-sheet, then point to the source cell on the monthly sheet, end with "enter". This creates the cell reference automatically. Repeat for each cell/month or use the syntax created to reference the other cells...

---

Was just wondering because 2007 offers a pretty good wizard for using other spreadsheets as data sources, but if what you've got works!

oh, and you can use a range, so =A4:A8, think that's what you need?


[Edited on 3/5/08 by madmandegge]

If the source data is on a row and you want the target data in the same way it is easiest to use the "fill in"-handle (small black square in the bottom right corner of the cell) on the target cell and expand the selection after the formula is complete. This way you can deal with a sheet at the time...

[Edited on 3/5/08 by Lippoman]

Brilliant - all sorted, thanks for help chaps