Excel geekery

I use SUMIF a lot to keep an eye on stock in external warehouses.  The supplier sends me a worksheet with stock sorted by code.  I have the same code in a master sheet and with one particular supplier SUMIF doesn't work unless I retype the code over their code, or copy and paste special values from my code list to theirs.

I realise this is probably due to the formatting of the external worksheet, but I can't change that. Does anyone know how to get my sheet to read their sheet without retyping?

Comments

Sign In or Register to comment.