[access-uk] Re: an excel question
- From: "Adrien Collins" <adriencollins22160@xxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 22 Apr 2009 20:45:56 +0200
Hi Carol
Thanks, I'll give it a go, excel's an interesting and very
useful program.
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 Carol Pearson
Sent: Wednesday, April 22, 2009 6:00 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: an excel question
Adrian,
You will manage that, I think. Go to the sheet you want to
move and Alt+E for Edit Menu, and you'll find Move or Copy
sheet. Be sure to check a box if you want to copy but
otherwise go for move and you'll be able to work out in the
combo box where you want that particular sheet.
Hope that makes enough sense.
If you get stuck, come back please.
--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Wednesday, April 22, 2009 3:28 PM (UK time), Adrien
Collins at adriencollins22160@xxxxxxxxxxxxxx said:
> 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
** 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
** 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:
