Pulling data from one worksheet to another

[neospec]

I have 2 worksheets that I am working with.

One is a monthly Sales Report ran from our Accounting software, the other is a Sales Report Analysis.

Based on the MAS Code (a code in the Sales Report), I need it to goto the 2nd worksheet, find that MAS code - then the total $ for the Code - and insert it into another cell on Sales Report Analysis.

I'm a little lost on this one. If you want examples, let me know.[/code]

 

[Andrew Poulsom]

Welcome to the Board.

You should be able to use VLOOKUP for that. Check it out in Excel Help.

 

[neospec]

Ive read all through it and all about VLOOKUP, but it don't think it can do what I need.

Can I post the 2 excel files?