Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses in london - Copying a numeric total to another worksheet

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

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

Resolved · Low Priority · Version Standard

Reply Thu 24 May 2007, 16:40Delegate Nathan said...

Nathan has attended:
Excel Intermediate course
Powerpoint Introduction course

Copying a numeric total to another worksheet

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)

For upcoming training course dates see: Pricing & availability

Reply Thu 24 May 2007, 17:01Trainer Richard said...

RE: Copying a numeric total to another worksheet

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

Access articles

· Want to Become the Office Hero? MS Project Training Could be the Answer
· Why go on a Microsoft Access Training Course?
· Sub-reports And Sub-forms In Access 2007
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· How To Successfully Design An Access Database For A Paying Client

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips