How can I filter 2 spreadsheets to include only those entries that are
on both?

sheet 1 has ref number and address' of all, sheet 2 has ref number and
oputstanding balances of those that have overdue payments. I want to
send mailmerge letters to those customers with outstanding balances but
need to access their addresses from the other spreadsheet - there are
toomany to do manually.


--
Emilystorey
------------------------------------------------------------------------
Emilystorey's Profile: http://www.excelforum.com/member.php...o&userid=31534
View this thread: http://www.excelforum.com/showthread...hreadid=512263