Cross Referencing 2 Excel Spread Sheets

L

lindsay3884

Here's a question thats answer would make my work alot easier...Is
there anyway or software out there that can cross-reference two excel
speadsheets? Or is there anyway to indicate duplicates in an excel
spreadsheet. I am dealing with thousands of names and manually
emliminating duplicates is not possible. Can anyone help?

Thanks, LC
 
L

little_creature

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.


(e-mail address removed) said the following on 26.4.2007 17:32:
 
L

little_creature

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&que...
icate&mode=Match+ALL+words

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

Thanks CyberTaz,
I was looking for VBA I post sometime to delete duplicates or at least
I think so, I'm starting to be a bit confused when and where I did. I
could not work it out right at that moment for highlighting with
conditional formating.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top