Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Databases

	98.1 % recommend us
	More live stats...

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

Training information:

Databases

Resolved · Low Priority · Version 2003

Reply Wed 29 Jul 2009, 16:57Delegate Chikwe said...

Chikwe has attended:
Excel Advanced course
Project Intro Intermediate course

Databases

How to automate the importation of data into databases from inividual forms

For upcoming training course dates see: Pricing & availability

Reply Fri 31 Jul 2009, 11:49Trainer Simon said...

RE: databases

Hi Chikwe,

Thank you for your question.

I have found a link for you that explains how to take data from a form and place it in Excel.

You could try and record a macro that automates the process.

http://www.computorcompanion.com/LPMArticle.asp?ID=238

I hope this helps.

Regards

Simon

Fri 7 Aug 2009: Automatically marked as resolved.

Excel articles

· Learn How To Use Index And Match Functions In Excel
· Tips to Facilitate Printing of Excel worksheets
· Why do we even need XML anyway?
· How To Use Functions In Excel 2010
· Tools From Advanced Excel Courses: Goal Seek and Solver

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips