Hi, I want to add COMMAND BUTTONS (Or similar) to the following spreadsheet, but I don't know any VB code!:furious:
In column H I want COMMAND BUTTONS, when pressed I want the count in the next row to start at the NEXT CATEGORY. I am unfamiliar with the parameters of VB code, but in my spreadsheet it works detailed in "DESCRIPTION OF SPREADSHEET" below.
Example of what I want COMMAND BUTTONS to do, in H9, when command button pressed, row 10 count, starts count in next category
F10: A
G10: RANGE GROUP ii)
Perhaps control toolbox buttons (Or similar) is straight forward, or perhaps/maybe such COMMAND BUTTONS would need to calc the remainder of the current category:
Current Category Max, Column K - Current Category Running Total, Column M = REMAINDER
Then add remainder to current category in COLUMN M, then count starts at next category.
DESCRIPTION OF SPREADSHEET:
The formula fills (As much possible, without going over the max), the CATEGORIES only in order of RANGE GROUPS (5 ranges, each with 4 different categories):
"A", then "B", then "C", then "D", then if possible count starts again at "A", etc.
TIER RANGES example:
CATEGORY MIN MAX
A 0 100
B 0 300
C 0 500
D 0 800
DATA TABLE EG:
ROW 2, MISC ITEM, £50 X1 = £50, Running absolute total = £50, CATEGORY = A (Range A total so far = £50)
ROW 3, MISC ITEM, £30 X1 = £30, Running absolute total = £80, CATEGORY = A (Range A total so far = £80)
ROW 4, MISC ITEM, £30 X1 = £30, Running absolute total = £110, CATEGORY = B (Range B total so far = £30)
ROW 5, MISC ITEM, £50 X4 = £200, Running absolute total = £310, CATEGORY = B (Range B total so far = £230)
ROW 6, MISC ITEM, £80 X1 = £80, Running absolute total = £390, CATEGORY = C (Range c total so far = £80)
Cheers
Stephan