Recount for Period (i.e. change period number Start)

[HotNumbers]

PLEASE HELP. This issue has been a mystery for me for over a week.

How do I adjust the count on Column J (Adjusted Period) according to what I select in Column C (Quantity).

When I select In Column C -1130417 I want Column J to data for that row to start with one.
Example shown in Column L
Can A Macro be run that as you can see the determining factor on when to stop the count is Column A (Issue)

I want a macro button that will provide me a with some sort of a selection that I can choice which Quantity I want to adjust for Column J Period

******************************************************************

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Issue	Description	Quantity	Year	Qtr	Date	Period	Family	Name	Adjusted Period		EXAMPLe for Column J
2	017	SEASON 2		2007	1	12/31/2006	1	423	MONT	0		0
3	017	SEASON 2		2007	2	3/31/2007	2	423	MONT	0		0
4	017	SEASON 2	-730041	2007	3	6/30/2007	3	423	MONT	1		0
5	017	SEASON 2	-677351	2007	4	9/30/2007	4	423	MONT	2		0
6	017	SEASON 2	-1130417	2008	1	12/31/2007	5	423	MONT	3		1
7	017	SEASON 2	-108749	2008	2	3/31/2008	6	423	MONT	4		2
8	017	SEASON 2	-7765	2008	3	6/30/2008	7	423	MONT	5		3
9	017	SEASON 2	-1801	2010	2	3/31/2010	14	423	MONT	6		4
10	017	SEASON 2	-112	2011	1	12/31/2010	17	423	MONT	7		5
11	017	SEASON 2	829	2011	2	3/31/2011	18	423	MONT	8		6
12	018	MEET		2007	1	12/31/2006	1	613	CIRCUS	0
13	018	MEET		2007	2	3/31/2007	2	613	CIRCUS	0
14	018	MEET	-729012	2007	3	6/30/2007	3	613	CIRCUS	1		0
15	018	MEET	-672894	2007	4	9/30/2007	4	613	CIRCUS	2		0
16	018	MEET	-1123671	2008	1	12/31/2007	5	613	CIRCUS	3		1
17	018	MEET	-106542	2008	2	3/31/2008	6	613	CIRCUS	4		2
18	018	MEET	-10504	2008	3	6/30/2008	7	613	CIRCUS	5		3
19	018	MEET	3052	2008	4	9/30/2008	8	613	CIRCUS	6		4
20	018	MEET	-355	2010	3	6/30/2010	15	613	CIRCUS	7		5
21	018	MEET	-494	2010	4	9/30/2010	16	613	CIRCUS	8		6
22	018	MEET	-113	2011	1	12/31/2010	17	613	CIRCUS	9		7
23	018	MEET	829	2011	2	3/31/2011	18	613	CIRCUS	10		8
24	194	CONCERT		2007	1	12/31/2006	1	700	CHEET	0
25	194	CONCERT		2007	2	3/31/2007	2	700	CHEET	0
26	194	CONCERT		2007	3	6/30/2007	3	700	CHEET	0
27	194	CONCERT	-49906	2007	4	9/30/2007	4	700	CHEET	1
28	194	CONCERT	12607	2008	1	12/31/2007	5	700	CHEET	2
29	194	CONCERT	3665	2008	2	3/31/2008	6	700	CHEET	3
30	194	CONCERT	5393	2008	3	6/30/2008	7	700	CHEET	4
Sheet1

Excel 2007