Tell me there is a quicker way!!!!

[Krucifire]

Bunnings Trade Card Inbound_Outbound Call Stats (4).xls
	A	B	C	D	E	F	G	H
4		YTDTOTALS	Week8	Week9	Week10	Week11	Week12	Week13
5	Inbound
6	TotalweeklyHoursWorked(8am-6pmdaily)
7	TradeCardQuery
8	GeneralEnquiries	407	18	49	34	30	5	22
9	StatusofPriorApp	1620	50	61	51	37	31	36
10	CancelledCard	246	10	0	1	1	0	4
11	RenewalofCard	2291	11	18	11	14	22	9
12	NewApplication	869	16	13	18	19	17	10
13	TTLInboundTradeCardEnquiries	5433	105	141	115	101	75	81
14	OwnerBuilderQuery
15	GeneralEnquiries	203	9	22	24	21	5	11
16	StatusofPriorApp	349	12	26	19	17	8	10
17	CancelledCard	47	0	0	0	1	3	2
18	RenewalofCard	227	2	4	6	5	7	15
19	NewApplication	138	3	4	7	3	3	2
20	TTLInboundOwnerBuilderEnquiries	964	26	56	56	47	26	40
21	EscalatedCalls
22	TradeCard	163	5	1	7	7	6	1
23	OwnerBuilderCard	41	3	7	0	2	0	0
24	CreditAccount	13	0	1	0	5	0	0
25	TTLInboundEscalatedCalls	217	8	9	7	14	6	1
26	OtherCalls
27	CreditAccount	759	3	17	19	26	15	14
28	BunningsStores	689	7	12	12	6	13	8
29	AllOther	443	16	8	0	9	2	0
30	TTLOtherInboundEnquiries	1891	26	37	31	41	30	22
31
32	TTLInboundEnquiries	8505	165	243	209	203	137	144
33
34	InboundCallSummary
35
36	TTLTradeCardInboundCalls	3083	110	142	122	108	81	82
37	TTLOwnerBuilderCardCalls	368	15	15	14	13	3	8
38	TTLInboundRenewalApplications	1038	0	22	17	19	29	24
39	TTLInboundApplications	542	50	17	25	22	20	12
40	ConversionRatioApps:Calls	0.457838308	0.4	0.248408	0.308824	0.338843	0.583333	0.4
41
42	OutboundCalls
43	TradeCard	1891	27	39	26	46	13	9
44	OwnerBuilderCard	216	10	19	10	13	7	0
45	CreditAccount	113	3	4	6	13	2	0
46	TTLOutboundCallsMade	2220	40	62	42	72	22	9
47
48	MessageBank
49	NumberofMessagesLeft	77	77	0	0	0	0	0
50	MessagesfromBunningsStores/HeadOffice	4334	0	61	47	58	121	85
51	TTLMessagesleft	287	77	8	4	2	14	9
52	Irretrievablenumbers	4554	10	69	51	60	135	94
53	NumberofCallsReturned(Outbound)	1256	89	13	29	17	41	23
54		2789		65	59	55	100	79
55	Non-callActivity
56
57	TradeCardApplicationsProcessed	132	132	0	0	0	0	0
58	TradeCardRenewalsandReplacements	5509	21	106	55	62	39	41
59	TradeCardApplicationsDeclined	1025	27	27	24	23	25	15
60	OwnerBuilderCardApplicationsProcessed	365	36	5	1	17	0	1
61	OwnerBuilderCardRenewalsandReplacements	1138	15	31	13	26	8	41
62	OwnerBuilderCardApplicationsDeclined	125.2307692	8.230769	6	10	4	10	17
63	TTLApplicationsReceived	298	231	2	0	1	0	0
Summory

Ok if you look at the formulas above you will see how they are working its basically only the sheet name that is changing.

I have to do this formula for 170 weeks, and i REALLY REALLY REALLY dont want to do it 1 by 1... is there a quicker way to reference this data????

 

[Krucifire]

Ahh ok i understand now, thx heaps ill do that now, Fingers crossed i do it right.

 

[Krucifire]

Thx Denise, worked a treat and thank you for explaining it to me.. Pretty sure you just saved me about 3days work :D

 

[SydneyGeek]

You're welcome

Denis

 

[Krucifire]

appologies for the spelling error in your name too

 

[stanleydgromjr]

Krucifire,

I think I have it now.

Week 1 thru 6 are similar:

Excel Workbook
	A	B	C	D	E	F	G	H
4		YTD*TOTALS	Week*1	Week*2	Week*3	Week*4	Week*5	Week*6
5	Inbound*
6	Total*weekly*Hours*Worked*(8am*-*6pm*daily)
7	Trade*Card*Query
8	General*Enquiries	21	1	2	3	4	5	6
9	Status*of*Prior*App	21	1	2	3	4	5	6
10	Cancelled*Card	21	1	2	3	4	5	6
11	Renewal*of*Card*	21	1	2	3	4	5	6
12	New*Application	21	1	2	3	4	5	6
13	TTL*Inbound*Trade*Card*Enquiries	105	5	10	15	20	25	30
14	Owner*Builder*Query
15	General*Enquiries	21	1	2	3	4	5	6
16	Status*of*Prior*App	21	1	2	3	4	5	6
17	Cancelled*Card	21	1	2	3	4	5	6
18	Renewal*of*Card*	21	1	2	3	4	5	6
19	New*Application	21	1	2	3	4	5	6
20	TTL*Inbound*Owner*Builder*Enquiries	105	5	10	15	20	25	30
21
22	Escalated*Calls
23	Trade*Card	21	1	2	3	4	5	6
24	Owner*Builder*Card	21	1	2	3	4	5	6
25	Credit*Account	21	1	2	3	4	5	6
26	TTL*Inbound*Escalated*Calls	63	3	6	9	12	15	18
Week1

Excel Workbook
	A	B	C	D	E	F	G	H
4		YTD*TOTALS	Week*1	Week*2	Week*3	Week*4	Week*5	Week*6
5	Inbound*
6	Total*weekly*Hours*Worked*(8am*-*6pm*daily)
7	Trade*Card*Query
8	General*Enquiries	78	13	13	13	13	13	13
9	Status*of*Prior*App	78	13	13	13	13	13	13
10	Cancelled*Card	78	13	13	13	13	13	13
11	Renewal*of*Card*	78	13	13	13	13	13	13
12	New*Application	78	13	13	13	13	13	13
13	TTL*Inbound*Trade*Card*Enquiries	390	65	65	65	65	65	65
14	Owner*Builder*Query
15	General*Enquiries	78	13	13	13	13	13	13
16	Status*of*Prior*App	78	13	13	13	13	13	13
17	Cancelled*Card	78	13	13	13	13	13	13
18	Renewal*of*Card*	78	13	13	13	13	13	13
19	New*Application	78	13	13	13	13	13	13
20	TTL*Inbound*Owner*Builder*Enquiries	390	65	65	65	65	65	65
21
22	Escalated*Calls
23	Trade*Card	78	13	13	13	13	13	13
24	Owner*Builder*Card	78	13	13	13	13	13	13
25	Credit*Account	78	13	13	13	13	13	13
26	TTL*Inbound*Escalated*Calls	234	39	39	39	39	39	39
Week6

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Change the value in cell B6, and the formulae in column B will adjust automatically.		C thru FP = 170		C8	=INDIRECT("'" & C$3 & "'!" & "C" & ROW())
2	=SUM(OFFSET($C8,,,,$B$6))	Weeks	1	2	3	4	5	6	7	8	9
3		Sheetnames	Week1	Week2	Week3	Week4	Week5	Week6
4		YTD*TOTALS	Week*1	Week*2	Week*3	Week*4	Week*5	Week*6
5	Inbound*	Thru Weeks
6	Total*weekly*Hours*Worked*(8am*-*6pm*daily)	4
7	Trade*Card*Query
8	General*Enquiries	46	1	8	15	22	12	13
9	Status*of*Prior*App	46	1	8	15	22	12	13
10	Cancelled*Card	46	1	8	15	22	12	13
11	Renewal*of*Card*	46	1	8	15	22	12	13
12	New*Application	46	1	8	15	22	12	13
13	TTL*Inbound*Trade*Card*Enquiries	230	5	40	75	110	60	65
14	Owner*Builder*Query
15	General*Enquiries	46	1	8	15	22	12	13
16	Status*of*Prior*App	46	1	8	15	22	12	13
17	Cancelled*Card	46	1	8	15	22	12	13
18	Renewal*of*Card*	46	1	8	15	22	12	13
19	New*Application	46	1	8	15	22	12	13
20	TTL*Inbound*Owner*Builder*Enquiries	230	5	40	75	110	60	65
21
22	Escalated*Calls
23	Trade*Card	46	1	8	15	22	12	13
24	Owner*Builder*Card	46	1	8	15	22	12	13
25	Credit*Account	46	1	8	15	22	12	13
26	TTL*Inbound*Escalated*Calls	138	3	24	45	66	36	39
Summory

Have a great day,
Stan