You need to sign in to do that
Don't have an account?
APremo1005
Populating Fields
I am the administator for our marketing department. Our sales team is really large, so we aren't implmenting this tool to them...yet. I have an excel spreadsheet that has our territories broken down by zip code (quite large), and I need to somehow import the spreadsheet and auto populate new and current fields with this information based on the zipcode.
I think this is possible within a formula but I cannot make it work... and I have a TON of zipcodes to incorporate! Ideas? Comments? suggestions? Please help :smileysad:
So these are the fields I have:
Territory Manager, Regional Director, and Zone
The main issue is the territory manager. I want to be able to type in a zip code, save the file and have that field auto populate. AND if possible have the trickle effect to the other two fields (not as important).
Also, I don't know if it's possible but if there is a way to take the zip code + product type = Territory Manager that would be perfect.
Sound like I am in over my head? :smileyhappy:
Did u do this because I'm now in the same situation.
Help would be really great.