Background:
I am trying to create a spreadsheet that allows the user to record all items of furniture in a house room by room and their corresponding cubic foot volumes.
I have several worksheets depicting different rooms in a house, i.e Kithcen, Lounge etc...
On each of these sheets I have created a drop down list via the Data Validation method for all items likely to be found in these rooms.
What i want to do is when an item is selected in the drop down list for the corresponding cubic volume to be automatically entered in the adjacent cell.
Is this possible or is their a better way to do this?
All help greatly appreciated.
Thanks
I am trying to create a spreadsheet that allows the user to record all items of furniture in a house room by room and their corresponding cubic foot volumes.
I have several worksheets depicting different rooms in a house, i.e Kithcen, Lounge etc...
On each of these sheets I have created a drop down list via the Data Validation method for all items likely to be found in these rooms.
What i want to do is when an item is selected in the drop down list for the corresponding cubic volume to be automatically entered in the adjacent cell.
Is this possible or is their a better way to do this?
All help greatly appreciated.
Thanks