Adam has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel - Sorting
What is the best way to pull in information from one spreadsheet to another using a unique identifier. I.E. a product code is the same on two sheets but the price is different can I pull the price from one sheet next to the price in the other.
RE: Excel - Sorting
A simple vlookup could do this.
=vlookup(A1,sheet2!A1:E2000,2,0)
assuming that A1 is the product code.
sheet2!A1:E2000 is the range that vlookup is looking in
and that the price on sheet2 is in column B (second column along)
RE: Excel - Sorting
Paul,
Perfect thankyou, that's saved us about 20 hours a month!
Thanks,
Adam
RE: Excel - Sorting
Well done Paul, thank you for that response, it looks like Adam is well pleased. Best regards Pete.