Hi, can anyone help with a macro?
I have Data on sheet1 - AJ2 has the row Ref and AK2:AQ for the Data and column AS to add 1 for every row used.
I have two buttons on sheet2 I want to use as a Plus and Minus (E1 as Minus and F1 as Plus)
I want to click the Plus button to add 1 to next row in column AS(sheet1) and use the Minus button to remove 1 from the last row used in column AS and have the Ref from Column AJ(sheet1) show in D1(sheet2) for the row in use on sheet1
ie if the Plus button is clicked on sheet2 - then 1 would be added to AS5 and the Ref from Column AJ would show 4 in D1(sheet2) and if the Minus button is clicked - then 1 would be removed from AS4 and the Ref from Column AJ would show 2 in D1(sheet2)
Sheet1
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1353;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:768; width:16pt" width="21" span="7"> <col style="mso-width-source:userset;mso-width-alt:1170;width:24pt" width="32"> <col style="mso-width-source:userset;mso-width-alt:1353;width:28pt" width="37"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Sheet2 D1 is showing 3 as the Ref for the row in use in the above example
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>
Any help would be appreciated
Regards
pwill
I have Data on sheet1 - AJ2 has the row Ref and AK2:AQ for the Data and column AS to add 1 for every row used.
I have two buttons on sheet2 I want to use as a Plus and Minus (E1 as Minus and F1 as Plus)
I want to click the Plus button to add 1 to next row in column AS(sheet1) and use the Minus button to remove 1 from the last row used in column AS and have the Ref from Column AJ(sheet1) show in D1(sheet2) for the row in use on sheet1
ie if the Plus button is clicked on sheet2 - then 1 would be added to AS5 and the Ref from Column AJ would show 4 in D1(sheet2) and if the Minus button is clicked - then 1 would be removed from AS4 and the Ref from Column AJ would show 2 in D1(sheet2)
Sheet1
AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | |
1 | ref | Data | Used | ||||||||
2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
5 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
6 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
7 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
8 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
9 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
10 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
11 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
12 |
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1353;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:768; width:16pt" width="21" span="7"> <col style="mso-width-source:userset;mso-width-alt:1170;width:24pt" width="32"> <col style="mso-width-source:userset;mso-width-alt:1353;width:28pt" width="37"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
Sheet2 D1 is showing 3 as the Ref for the row in use in the above example
D | E | F | G | H | |
1 | 3 | - button | + button | ||
2 | |||||
3 |
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>
Any help would be appreciated
Regards
pwill