hi,
I've spent quite a few hours today trying to search for a solution to this and concluded it has something to do with Match and Index, but, can't for the life of me to get it all to work.
I don't think it strictly has to be a macro - a formula may work - but this is what i want to do:
In one sheet (called db) i have over 50,000 entries which relate to stock items seperated into style, colour, size and barcode.
In the other sheet i have a download of my stock database (called stck) which (after some manipulation) also has columns split into style, colour and size. This has about 700 items in it.
What i need to do is for all 700 items search through the db sheet and match style, colour and size, then copy the barcode from the db sheet to the stck sheet.
I know it ***should*** be simple to do, but, i can't for the life of me work it out, so any help / advise / solutions would be really really appreciated.
My excel sheet can be downloaded as a zip from here:
http://www.surplushardwaresupplies.c...xcel/addbc.zip
The upload utility keeps erroring on me for some reason, sorry...
Thanks
Mike
Bookmarks