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]
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]