New to Formulas - Need a Formula to link one cell to another

[krazeehair]

Hi All,
Thank God I found this forum. I've been driving myself crazy trying to find the answer to this question.
I'm creating a spreadsheet for employee evals - mid year/annual. I want to be able to type someone's name in mid year cell and have it pop up in the cell for annual. Example:

Please Login or Register  to view this content.

December names will pop up in 1st Quarter, April 2nd Quarter, July - 3rd Quarter, etc. Dec would be A5 cell and I want that same name to pop up in F5 cell, whatever the name may be. Since the names will all be different.

Hope someone can help me soon.

[majosum]

Hi there.

Underneath "Q1-June", if the first cell is F5, then you could type: =A5. This will return the value from the December column. If you drag this formula down so that the next rows will be =A6, =A7, etc., it will automatically populate the cells in column F. You can do the same in columns G, H, and I by referencing columns B, C, and D, respectively.

Is this of help?

[krazeehair]

Hi there.

Underneath "Q1-June", if the first cell is F5, then you could type: =A5. This will return the value from the December column. If you drag this formula down so that the next rows will be =A6, =A7, etc., it will automatically populate the cells in column F. You can do the same in columns G, H, and I by referencing columns B, C, and D, respectively.

Is this of help?

Thanks so much! The only think I need to know is how do I clean it up so that zeros won't show up in the cells without data.

[majosum]

Sorry, I didn't take that into account.

Instead of typing "=A5" in cell F5, type =IF(A5="","",A5)

This formula states: if the cell(A5) is empty, return nothing. If it is not empty, return cell A5.