Hi David
it looks very easy when you know how! If I add more data in
sheet 1 I assume it will automatically up-date the spread
data on all the sheets on which I have used the formula you
have given me. Also, my work book has 6 sheets in it, they
are jumbled up, sheet is at the bottom, sheet 6 is before
sheet 3, how can I put them in the correct order?
Regards
Adrien
You can get me off list at:
adriencollins06@xxxxxxx
or
adrien_collins@xxxxxxxxxxx
Or
adrien.collins@xxxxxxxxx
Speakon is a free fully self-voicing accessible multimedia
program for
the visually impaired, find out more by downloading the
software from:
http://www.a-technic.net/speakon.htm
You can join the speakon user group by sending a blank
e-mail to:
speakon-subscribe@xxxxxxxxxxxxxxx
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx
[mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of David W Wood
Sent: Wednesday, April 22, 2009 4:18 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: an excel question
Adrian:
By default, Excel provides three sheets in a workbook.
These are labelled, sheet1, sheet2 and sheet3 by default.
They can be renamed however - that's another story.
If your data is in sheet1 at present, then go to the next
sheet (2) by
pressing:
Ctrl+pgdn
If the total cell in sheet1 is cell d9, in sheet2 at your
chosen point you put in the formula:
=sheet1!d9
That should do it.
I strongly recommend that you find John Wilson's tutorial
and peruse it.
HTH
David W Wood
GUILDFORD PHYSIOTHERAPY AND SPORTS CLINIC MATTHEWS HOUSE
85 EPSOM ROAD
GUILDFORD
SURREY GU1 3PA
T: 01483 575876 (APPOINTMENTS)
302691 (ALL OTHER INQUIRIES/FAX)
E: reception@xxxxxxxxxxxxxxxxxxx
W: http://tinyurl.com/5wptcp
____________________
DISCLAIMER
The information contained in this e-mail is strictly
confidential and is intended solely for the individual/s to
whom it is addressed. If you are not the intended recipient
or have received this e-mail in error please delete it
immediately. Any disclosure including but not withstanding
reading copying or distribution of all or part of the
information contained herein is strictly prohibited and may
be unlawful. Although this email and any attachments are
believed to be free of any virus or any other defect which
might affect any computer or system on which they are
received and/or opened it is the responsibility of the
recipient to ensure that they are virus free and no
responsibility is accepted by The Guildford Physiotherapy
and Sports Clinic for any loss or damage arising in any way
from receipt or use
thereof. Any opinions or advice contained in this email
are not
necessarily those of The Guildford Physiotherapy and Sports
Clinic or any individual or individuals working or acting on
its behalf.
Any prices shown are in pounds sterling and include VAT.
Delivery and Expense charges are excluded unless otherwise
stated.
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx
[mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Adrien Collins
Sent: Wednesday, April 22, 2009 2:57 PM
To: 'access uk'
Subject: [access-uk] an excel question
Hi
I use a workbook in excel to keep track of my finances. I
would like to automatically have the total of one
spreadsheet entered into the columns of another spreadsheet
in the same workbook, is this possible? Could you please
tell me how to do it?
Regards
Adrien
You can get me off list at:
adriencollins06@xxxxxxx
or
adrien_collins@xxxxxxxxxxx
Or
adrien.collins@xxxxxxxxx
Speakon is a free fully self-voicing accessible multimedia
program for the visually impaired, find out more by
downloading the software from:
http://www.a-technic.net/speakon.htm
You can join the speakon user group by sending a blank
e-mail to:
speakon-subscribe@xxxxxxxxxxxxxxx
** To leave the list, click on the immediately-following
link:-
**
[mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on
the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.12.2/2074 - Release
Date: 04/22/09 08:49:00
