leighton367
New Member
- Joined
- Jan 28, 2015
- Messages
- 2
I am having trouble with a macro button, that links to two drop-down boxes. My main sheet (YYD), has two drop-down boxes that reference my other sheet (Data). The first drop-down in YYD!F12 selects a row and the second drop-down in YYD!F17 selects the column on my 'Data' Sheet. I just need a macro that when I click a button, I have created, it references the two drop downs for row/column and adds +1 to that cell on my data sheet.
I have made the Lookup formula for the sheet 'YYD' so the user can see the value currently in the cell select by the 2 drop-downs, but haven't came up with any ideas on where to start with the macro.
Lookup Formula for Drop-downs -
=VLOOKUP(YYD!F12,Data!A2:E95,((IF(YYD!F17=Data!B1,2,1))*(IF(YYD!F17=Data!C1,3,1))*(IF(YYD!F17=Data!D1,4,1))*(IF(YYD!F17=Data!E1,5,1))),FALSE)
If any one could help me put together a macro that would work for this, Any help would be much appreciated.
Or if you need more info, or have any question I would be glad to help.
Thank you.
I have made the Lookup formula for the sheet 'YYD' so the user can see the value currently in the cell select by the 2 drop-downs, but haven't came up with any ideas on where to start with the macro.
Lookup Formula for Drop-downs -
=VLOOKUP(YYD!F12,Data!A2:E95,((IF(YYD!F17=Data!B1,2,1))*(IF(YYD!F17=Data!C1,3,1))*(IF(YYD!F17=Data!D1,4,1))*(IF(YYD!F17=Data!E1,5,1))),FALSE)
If any one could help me put together a macro that would work for this, Any help would be much appreciated.
Or if you need more info, or have any question I would be glad to help.
Thank you.