Jasper
|
| posted on 3/5/08 at 01:58 PM |
|
|
Any Excel Experts
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 
If you're not living life on the edge you're taking up too much room.
|
|
|
|
|
madmandegge
|
| posted on 3/5/08 at 02:02 PM |
|
|
What version of office are you using?
|
|
|
Lippoman
|
| posted on 3/5/08 at 02:06 PM |
|
|
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...
|
|
|
Jasper
|
| posted on 3/5/08 at 02:18 PM |
|
|
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...
That works a treat, anyway I can do a line of figures at a time, or do that all have to be individual?
BTW Office 2007
If you're not living life on the edge you're taking up too much room.
|
|
|
madmandegge
|
| posted on 3/5/08 at 02:23 PM |
|
|
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]
|
|
|
Lippoman
|
| posted on 3/5/08 at 02:27 PM |
|
|
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]
|
|
|
Jasper
|
| posted on 3/5/08 at 02:44 PM |
|
|
Brilliant - all sorted, thanks for help chaps 
If you're not living life on the edge you're taking up too much room.
|
|
|
