In desperate need of help....

[mrskitz]

Hello there,

I am writing to you in the hope you can help me resolve a database
issue I am currently having. It is quite urgent and ideally needs to be
resolved ASAP. Please find attached an MS Excel file with a sample my
database on sheet1 and the desired outcome on sheet2.

Basically, my database has around 20,000 items on it, many of which are
duplicates and I need the file to be altered so that each title is only
listed once, but the quanity figure amended accordingly. Also, our
reference number is stored within the 'item-note' column. It is vital
that for each title, we have all the reference numbers for all copies
in this column.

I hope this helps explains our problem and the demo attached shows you
what we're after.

DEMO AVAILABLE FROM:
http://s50.yousendit.com/d.aspx?id=...XX0GC7UFB935O5Z

Thank you for your time and help,

Tom Rowley

 

[dh01uk]

Hi Tom

Sounds like a similar problem to mine!!!

I'm hoping that by looking at your spreadsheet I might be able to find
a olution for us both (I've come to a dead end on mine at the moment)

However your link doesn't work!!!!

 

[mrskitz]

Hi.

Drop me an email and I can send you a demo file as an attachment.

(e-mail address removed)

Thanks

Tom

 

[dh01uk]

Hi

I've sent you my e-mail address if you check your inbox and send doc,
i'll take a look.

Regards

dh01uk