[access-uk] Re: an excel question

  • From: "David W Wood" <g3yxx@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: <access-uk@xxxxxxxxxxxxx>
  • Date: Wed, 22 Apr 2009 15:17:46 +0100

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


-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 508 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

** 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

Other related posts: