Yes if you just input the following formula in your cell were you want the figures to appear, entering the appropriate details were necessary.
Make sure you use the apostrophies and exclimation mark as I've put them below. * worksheet name is the name of the worksheet were the cell you want to copy is
* cell ref is the cell you want to copy ='WORKSHEET NAME'!cell ref Peter -------------------------------------------------- From: "Adrien Collins" <adriencollins22160@xxxxxxxxxxxxxx> Sent: Wednesday, April 22, 2009 2:56 PM To: "'access uk'" <access-uk@xxxxxxxxxxxxx> 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
** 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