Mac Forum / Applications / Excel / April 2007

To link 2 sheets
It's same like you are doing references in the same sheet. To link data
just click to the cell in which you would like to see the entry from
second sheet and type there =
Then navigate (by mouse) to the sheet you want to get information from.
Now You should see formula in the cell something like this =sheet2!Q30

The same is true when you need to link 2 files, all you need do to is
have them both workbooks opened, and then also by inserting = and
clicking to the appropriate cell in the other workbook you will
reference the data.
{{Just to note when you reference 2 files -then when you close your
documents, next time you open the file containing the references, you
will be asked if you want to update the links-this updates the entry (if
you change the entry in the source file, this will also update the entry
in the workbook containing the references).}}

I will look for macro for checking duplicates meanwhile. Hope this help.

lindsay3884@gmail.com said the following on 26.4.2007 17:32:

You might find what you seek here thanks to the generosity of Chip Pearson,
particularly items #1 & #3:

http://search.freefind.com/find.html?id=6958140&pageid=r&mode=ALL&query=dupl
icate&mode=Match+ALL+words

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 4/26/07 11:32 AM, in article
1177601558.043693.129160@t38g2000prd.googlegroups.com,