cross reference two spreadsheets using MS Excel

G

Guest

Is it possible to have two spreadsheets in two different files and cross
reference the data using excel vs. manually hand checking the sheets. The
sheets are using text not numbers.
 
B

Bernard Liengme

Not sure I follow question
Here is an exercise that will not upset you files while you experiment.
Open one of your files (let us pretend it is called File_A)
Open a new workbook, type = and then click on a cell in File_A
You should see a formula such as ='[File_A.xls]Sheet1'!$C$1

Is this what is needed? Come back with more info, it not.
best wishes
 

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

Similar Threads

How do i cross reference two excel spreadsheets? 6
Cross referencing, fidning matching data 4
I need to know which function to use. 3
Need help find automate way to cross reference two GAINT excel databases!! 1
How can I cross reference 2 excel docs to look for duplicate info 1
Using Packing Slip Template 1
Comparing two spreadsheets 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top