I have a worksheet populated via a data-source which lists dates, vertically as well as horizontally. 

* The dates vertically are items which
require action.
* The dates horizontally are the coming working week dates.

At this time, all I want to do is select the corresponding column of the horizontal row based on whats found in the vertical row. I will try and do a simple diagram. 

Date 3 2 1 4 5 6 7 8 9 

1

3

9

In this example; I would like to select the Column of the horizontal row for 1 (if this were a new worksheet id expect it to be Column D. I also need to be able to do this by running a macro, i.e. I can't be clicking in any cells initially.