access vba courses in london - Copying a numeric total to another worksheet

The UK's most regular instructor-led training courses.
Training information: access vba courses in london · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Copying a numeric total to another worksheet

Nathan has attended:
Excel Intermediate course
Powerpoint Introduction course

by - delegate Nathan [4 posts] (2007 May 24 Thu, 16:40) Reply

How do I copy a numberic total (that is the result of a formula) automatically to a cell on another workseet? e.g. a closing sales total that you want to be the opening sales figure on the next worksheet (without the formula copying)

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Copying a numeric total to another worksheet

by - trainer Richard platinum contributer [818 posts] (2007 May 24 Thu, 17:01) Reply

Hi Nathan

If your closing sales total is in D12, then go to your next sheet, and press =, then click on the first sheet, and then click on D12. It will bring the value through to the new sheet.

Regards

Richard

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Innovation with Microsoft Access
· Discover the Secrets within Your Business through Microsoft Access Training
· Access VBA Handling Errors and Debugging Code
· How Reorganising Your Data Can Take Your Business to the Next Level

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips