Hi I am trying to do 2 things that I need help with.

1. The first and more than likely a simple one... I am trying to
populate a cell (say for example A1) automatically with the same
information that is entered in a2.

I have been just using =A2 in the cell A1, but this inputs 0 until
someone populates A2. Is there an easy way to clean up the 0 or
should I use a function for this?

2. I have job titles which match up to competencies on a hidden
worksheet, the table would look like this:
Grade Competency Description
Grade A Communication Strong communicators demonstrate......
Grade A Planning Planning is all about.........
Grade B Innovation Is all about..........

There are 4 grades and I want to enable users to populate on a front
sheet their employee information (including a cell with Grade A,b,c or
D in a dropdown) then based on the grade that is selected the relevant
competencies are pulled from the hidden worksheet and dumped onto a
visible worksheet.

Please Help