Hi,

I'm very new to using VBA, but hoping that there is a simple solution to my situation:
1. I have a table of cell addresses, under a set of "codes" (F, NC, PL, etc.) i.e. (sorry, having hard time getting the table layout to display properly):

| AJ | AJ | AK | AM | AN | AO | AP | AQ

9 | F | NC | PL | FL | P1 | P2 | P3 | P4
10 | $F$10 | $J$10
11 | | | $H$11 | $L$11
12 | | | | | $H$11 | $Q$11 | $Y$11

2. I would like to populate the target cells (elsewhere in the same sheet) rerefenced by the addresses in each of the cells in the table, with the code at the top of each column in the table. For example, the cell f10 would be populated with the value "F", cell J10 with the value "NC"...right through to Y11 being populated with the "P3" value.

I'll reiterate that I'm very new to VBA, so likely need some step-by-step direction, plus the code! Any help would be much appreciated. Thanks.