Using Macro Buttons to change the values of cells back and forth.

[PuceSpade]

I would like to have a data set, with dates as column headers and unique codes as row headers, that can switch between different values. For example, Retail ($) and Tonnage. My first thought was to use Macros to populate a cell above the column headers that would be referenced in a VLOOKUP to designate a column to look in. However, that would only work if I had a Macro button for each date. Therefore, I tried to make the Macro button populate a cell with an HLOOKUP and that cell would be references in a VLOOKUP for the column index number. However, the equation would not work.

 

[Micron]

I would like to have a data set, with dates as column headers and unique codes as row headers, that can switch between different values. For example, Retail ($) and Tonnage.

No idea what that means but I'll take a stab at the problem anyway. If the date in a cell is the key, why not use the BeforeDoubleClick event? The value can be retrieved from the Target parameter of the event. To illustrate only that point perhaps try this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

MsgBox Target
Cancel = True

End Sub

If that doesn't get you anywhere I think you'll have to explain better. Maybe post some sample data and desired results as pics or something else.