data to fill in the next free cell

A

alann2

Hi all,
complete excel beginner here. I would like to know how if I select data
from a drop down list on sheet a. how could I have the same data entered
into a cell onto sheet b. Thats the basics that I can do, the part I
can't do is for the data to see if there has already been something
entered into the cell and then look for the next cell down and put the
data in there.
 
Top