Excel wizards????
I'm no expert with Excel...
but I'd like to have a data entry "box" with a drop down listing of various cameras and link the choice via a look-up table to supply data into say 5 cells ie pixel size, sensor size, dark current etc etc.
These populated cells are then used for various calculations in the spreadsheet.
Can anyone give me some leads????
|