|
Lorenzo, tx | I have a sheet that Im using to figure my farm budget for the year. I have a page that has crop income, A row that has Crop, Acres Yield Price and gives a total dollars at the end. I have a price list and want the price column to reference that price when I select what it is. So when I select Irr Corn in my drop down box for that row it would automatically insert the corn price from my price list. Im tired of having to go change the price in 15 rows anytime I wanna change a crop on that field or see what it would look like if the price change for that crop. It would also eliminate keystroke errors. Ive tried writing my own rule in condition formatting but cant make it work. Clear as mud? Id appreciate any help. Thanks! | |
|
excel question.
