Hi all,


My name is Emma and this is my first post so hoping you can help me.
I'm working on a carbon footprint calculator and i have a table which works out carbon emmissions for car usage. The table has 'Miles Travelled' across the top and 'MPG' down the side (see attached). I would like the user to be able to make a selection from the table, and that selection to then appear in another cell somewhere else on the worksheet. If they change their mind then the other cell would also update to the new selection. Is this possible ?
Hope i've explained it ok. Any help would be greatly appreciated

Thanks
Em

Attached Images

Carbon.JPG (21.8 KB, 21 views)