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 » Multiple spreadsheets

	98.1 % recommend us
	More live stats...

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

Training information:

Multiple spreadsheets

Resolved · Low Priority · Version 2007

Reply Wed 24 Nov 2010, 16:17Delegate Robert said...

Robert has attended:
Excel Intermediate course

Multiple spreadsheets

How to link formulas from multiple spreadsheets

For upcoming training course dates see: Pricing & availability

Reply Mon 29 Nov 2010, 09:26Trainer Simon said...

RE: Multiple spreadsheets

Hi Robert,

Thank you for your question.

Open the two spreadsheets up and start a formula with an equals sign. Switch to the first workbook and select the cell you need to use. Choose the appropriate Operator( - + * etc.) and select another cell in the second workbook. Any changes made to the first workbook will update the formulas in the second workbook.

Alternatively, if there is a formula in a cell in workbook one that you want linked to a cell in workbook 2 then start with an equals sign in workbook 1. The next step is to switch to workbook two and select the cell with the formula in and press enter. This means the two workbooks are linked.

I hope this answers your question.

Regards

Simon

Sun 5 Dec 2010: Automatically marked as resolved.

Excel articles

· Some Examples Of Excel Text Formulas
· Excel Offers A More Relaxing Way To Work Out
· How We Got To The Perfect Spreadsheet: A Brief History
· Sparklines And Splicers: The New Face Of Excel 2010
· Microsoft Excel Training: Not Just for Newbies Anymore

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

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips