I have an Excel Project to do as part of my work, here is th
situation:

I need to make a commission calculator known in the workplace a
"Doshometer" I need to spreadsheet to be able to pull information fro
another spreadsheet for example:

If i enter a product code i want the spreadsheet to automatically pul
the Discription, price and commission from another spreadsheet, so b
just entering the product code the main spreadsheet will automaticall
fill in the rest of the information.

Sounds complicated i know but i only have six week to produce a workin
Doshometer. Can you excel guru`s help me out of a hole

--
Message posted from http://www.ExcelForum.com