ICEINSPACE
|
Moon Phase
CURRENT MOON
Waning Crescent 5.6%
|
|
25-05-2013, 10:30 AM
|
 |
Registered User
|
|
Join Date: Oct 2005
Location: Junortoun Vic
Posts: 8,927
|
|
|
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????
|
25-05-2013, 10:46 AM
|
 |
Big Scopes are Cool
|
|
Join Date: Jun 2007
Location: SE Tasmania
Posts: 4,574
|
|
|
Is this what you are trying to do Ken - select camera in cell E8 and corresponding values for camera data are in d8, g8, h8. Table of data is in e1:h6. You use data validation to define the list for the dropdown box to select the camera.
|
25-05-2013, 11:07 AM
|
|
Registered User
|
|
Join Date: Oct 2005
Location: Junortoun Vic
Posts: 8,927
|
|
|
Peter,
Thanks for the input.
I've added some comments to the spreadsheet to better explain what I'd like to achieve....
|
25-05-2013, 11:11 AM
|
 |
Spam Hunter
|
|
Join Date: Jun 2005
Location: Oberon NSW
Posts: 14,438
|
|
|
You might also like to have a look at the VLOOKUP or HLOOKUP commands...
Put all the data about your cameras in a table (a range a the spreadsheet) and use VLOOKUP, say, to extract data to the cells you want.
Al.
|
25-05-2013, 11:15 AM
|
|
Big Scopes are Cool
|
|
Join Date: Jun 2007
Location: SE Tasmania
Posts: 4,574
|
|
|
I've added the necessary functionality - select camera from dropdown box and the other values will update.
|
25-05-2013, 11:16 AM
|
|
Registered User
|
|
Join Date: Oct 2005
Location: Junortoun Vic
Posts: 8,927
|
|
|
Al,
I already do that. But I'd like to add the option of a drop down "one click" camera menu which would automatically enter the other data in the other cells.
See the revised spreadsheet for details.....
|
25-05-2013, 11:17 AM
|
|
Big Scopes are Cool
|
|
Join Date: Jun 2007
Location: SE Tasmania
Posts: 4,574
|
|
|
Can't you see the dropdown in cell C1?
|
25-05-2013, 11:37 AM
|
|
Registered User
|
|
Join Date: Oct 2005
Location: Junortoun Vic
Posts: 8,927
|
|
|
Peter,
yes!!
100% what I was looking for - many, many thanks.
Greatly appreciated!!
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +10. The time is now 03:23 AM.
|
|
