Excel

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

Resolved · Low Priority · Version 2003

Excel

Julie-Anne has attended:
Excel Advanced course

by - delegate Julie-Anne [1 post] (2008 May 12 Mon, 16:49) Reply

how to past information from one sheet to another and keep the same colume row with?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel

by - trainer Tracy platinum contributer [586 posts] (2008 May 13 Tue, 05:43) Reply

One thing you can do is select two tabs holding your control key down, from there whatever you do with one worksheet affects the other. So you can type on one and it will appear on both sheets. If you are looking at row width if you change one it will change the other.

Have a go and see if that helps

Tracy

· Reasons Why VBA for Excel Training Fails
· Microsoft Excel Training Course
· Advanced Excel Training - takes you to the next level
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Training: Not Just for Newbies Anymore

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

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips