How to fill a cell with the data from an active cell with a specific range

[MrJason]

Hello,

I am trying to have an active cell within a range of cells populate into an empty cell at the top of the column range. I'd like to do this at the top of multiple column ranges.

B1 will equal a selection from B2-B15
C1 will equal a selection from C2-C15
etc.

I can do this using a drop down list when defining a cell value but I'd rather select the cells directly from the spread sheet.

I've seen it done where "B1"=ActiveCell, but that only works for B1. How will i do the same thing for C1, D1, E1 etc.

Thanks for you help.