Excel

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

Resolved · Low Priority · Version Standard

Excel

Chantel has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Chantel [3 posts] (2008 Mar 12 Wed, 16:52) Reply

how do we feed data from one sheet to another

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: excel

by - trainer Pete platinum contributer [864 posts] (2008 Mar 27 Thu, 11:37) Reply

Hi Chantel, Thank you for your post, in answer to your question, the most straighforward way of linking data from one sheet to another is to use the equals sign (=) in your destination cell, then navigate to the cell you wish to link to (source), select it and press the enter key. This now ensures that any data in the source cell will be displayed and is available to be used in any formulas or functions from the destination cell. Note any changes made in the source cell will be reflected in the destination. I hope that helps, best regards Pete.

· Crazy Things People Have Done With Excel
· Microsoft Excel Features and Functions for Accountants
· Why Should I Learn Visual Basic in Excel?
· Excel Macros for the Non-Programmer
· How to Create Better Excel Spreadsheets: Part Four

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips

Rate this page: