Need Help with Macro Button to add 1 to cell based on dropdowns (Row/Column)

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.
 

Forum statistics

Threads
1,085,495
Messages
5,384,007
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top