Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, December 22, 2009 – Permalink –

Link Workbooks

Tie them together


Excel is a flatfile database, but you can do some Access kinds of relationships.


"A link is a formula that gets data from a cell in another workbook. When you open a workbook that contains links (a linking workbook), Microsoft Excel reads in the latest data from the source workbook or workbooks (updates the links).

Use links when you want to maintain information in a single workbook, but also use the information in other workbooks. For example, if your product prices change frequently, you might keep a master price list.
Other workbooks that use the price data in calculations, such as purchase orders, inventory valuations, or sales estimates, can create links to the price list workbook so calculations always use current prices. When prices change, you only have to enter the new prices in one place."


  1. Open both workbooks.

  2. In the source workbook, select the cells you want to link to and click the Copy button.

  3. Switch to the destination workbook and click the upper left cell of the range where you want the links.

  4. On the Edit menu, click Paste Special, and then click Paste Link.
Create and Manage Links




See all Topics

Labels: ,


<Doug Klippert@ 3:10 AM

Comments: Post a Comment