Mac Forum / Applications / Excel / July 2008

On 6/24/08 2:16 PM, in article 59b522d4.-1@webcrossing.caR9absDaxw,

I'm not sure from your description exactly what you want to do. But with
both workbooks open, in one worksheet, enter an equals "=" in a cell and
then click on the cell in the other workbook. Press enter. Now, the first
cell will get it's value from the second. With the second file closed, the
value will remain fixed. It will update automatically when the second
workbook is opened.

Yeah, that seems to work with a single cell, but the main Excel file needs to link to smaller Excel files. I would like to create a large list of parts in one workbook, and then separate these parts into categories in other workbooks - a separate workbook file for each category. These separate category files would then link to the larger main list of parts, so if we needed to update them, we wouldn't have to update both lists.
Ex: If we needed to add a carburetor to the "engine" category Excel file, it would automatically add this to the larger Excel file of parts. Is this any clearer, . . . muddier . . ?

thanks
Michael

I'm using ctrl+tab, but that has the effect of pressing 'enter' and not putting in the link.

Please help, this should be so easy.