[Malvern] Comparing excel sheets

[Phil Ironside]

Yo

A client of mine wants to be able to do the folowing

_______________________________________________

Every Saturday morning I would like to download our eBay shop listings into
Excel (which is not a problem) and also download our internet shop listings
into Excel - again not an issue. The comes about from the fact that we add
stock to eBay every day and, of course, we are selling items from both daily
too! So what I want to do is compare the two spreadsheets and produce two
results:-

1) a list of items on the eBay download which do not appear on the Shop
download
2) the reverse of (1)

Therefore the items which are produced  in list (1) need to be uploaded to
the shop and the results of list (2) need to be deleted from the shop.

Anyway, all I require is the VBA that will produce the comparison lists as
(1) and (1) above, is this something you can do?


_______________________________________________


As I do not have the time to do this at the moment I wondered wheter any one would be interested in doing it or have had to solve a similar problem in the past.
Remember these people are not geeks. 

-- 
Cheers
Phil Ironside

Creative Spaces
01684-561495

http://creativespaces.co.uk
http://malvern.lug.org.uk
http://birmingham.pm.org