[Malvern] Comparing excel sheets

[Ian Pascoe]

Yep, I can do that one.

I'll take it off list as it's not quite, ahem, LInux!

E

PS What licence should I publish under guys?

-----Original Message-----
From: malvern-bounces at mailman.lug.org.uk
[mailto:malvern-bounces at mailman.lug.org.uk]On Behalf Of Phil Ironside
Sent: 17 September 2007 13:16
To: malvern at mailman.lug.org.uk; birmingham-pm at pm.org
Subject: [Malvern] Comparing excel sheets


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

_______________________________________________
Malvern mailing list
Malvern at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/malvern