Hello All,

I feel like I could figure this out but would rather save myself time.

I created templates for our sales people to use to enter their forecasts into. They supply 3 fields and then there are about 10 fields that based on the part number lookup in a separately maintained master reference file by part. I'd like for them to be able to see as they plug in there parts that the lookups pull the correct info or if N/A they know they need to go to the master to fill in that new part.

Curious if there is a way to do this without have everyone have to open the spreadsheet for the lookups to work for them.

Thanks,

CMO