Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Jennifer has attended:
Excel Intermediate course

by - delegate Jennifer [1 post] (2008 Feb 28 Thu, 16:49) Reply

How would I write a formula that copies information from a cell on one workbook to a cell on another workbook? For example, numerical data, not a sum.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Formulas with value

by - trainer Katie gold contributer [208 posts] (2008 Mar 3 Mon, 13:02) Reply

Hi Jennifer,

Thank you for your question.

In order to link just a number but not the formula from another file, you must have the two files open first.

1) On file one, set up your formula by type in =
2) Use the mouse to click on the cell you need on File 2
3) Press Enter

You should see the number showing on File 1 but not linking the formula.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another X question?

Have a great day.

Regards,

Katie Woo
(Microsoft Office Specialist Trainer)

· How to Create Better Excel Spreadsheets: Part Two
· How to Create Better Excel Spreadsheets: Part Three
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Identifying Suitable Candidates For VBA For Excel Training
· Compare Different MS Excel Training Methods

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

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips