Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

ecrtiger

macrumors newbie
Original poster
Jun 4, 2010
1
0
I'm creating a sales worksheet form and have drop down boxes for the part numbers, terms, etc. I have two questions..

1. Is there a way to make an if, then statement in a cell - if part number 'x' is chosen then populate the next cell with 'y'? Or do I just need to create lots of drop downs?

2. Will drop down (or pop ups) export to excel?

Thank you!!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.