A macro to consolidate many budgets into summary sheet

[Kim B]

Hello all. I have tried to take code from other board posts and make it work with what I am trying to do and am failing miserably. This macro is not that difficult, at least I don't think so compared to what I have seen done. I have 100 budgets that need to be consolidated into a seperate summary sheet. Column D5 on the first html, will determine what dept the budget comes from. So column b on the second html will change when the range has been exhausted on each budget. The range is B9:B132 from the first html. The directory in which the budgets are stored is g:\accounting\private\msdacct\planning\2011\budgets\budgets reviewed.

Thanks in advance

Excel Workbook
	B	C	D	E	F	G	H
1
2
3
4
5		DEPARTMENT:	69311	INFORMATION SYSTEMS
6		MANAGER:
7
8	ACCOUNT	DESCRIPTION	Q1	Q2	Q3	Q4	2010
9	502104 - UA	OTH NON-OH EXP - TAXES					0
10	511101 - UA	SALARY & WAGE - INDIRECT LABOR	96,980	99,241	99,241	99,241	394,703
11	513004 - UA	EMPLOYEE - TRAINING	3,500	3,500	3,500	3,500	14,000
12	520001 - UA	TRAVEL EXPENSE - TRANSPORT AIR	3,000	3,000	3,000	3,000	12,000
13	520002 - UA	TRAVEL EXPENSE - TRNSPORT LAND	1,200	1,200	1,200	1,200	4,800
14	520003 - UA	TRAVEL EXPENSE - ACCOMMODATION	3,000	3,000	3,000	3,000	12,000
15	520004 - UA	TRAVEL EXPENSE - MEALS	1,080	1,080	1,080	1,080	4,320
16	520005 - UA	TRAVEL EXPENSE - ENTERTAINMENT					0
17	520007 - UA	TRAVEL EXPENSE - GENERAL	200	200	200	200	800
18	531003 - UA	RENTS - OFFICE EQUIPMENTS					0
19	531012 - UA	REPAIR & MAINTENANCE - MACH	1,750	1,750	1,750	1,750	7,000
20	531013 - UA	REPAIR & MAINTENANCE					0
21	531091 - UA	COMMODITY - PPV					0
22	531201 - UA	TELEPHONE	10,045	10,045	10,045	10,045	40,180
23	531203 - UA	IT NETWORK	12,875	10,450	10,450	10,450	44,224
24	531204 - UA	SOFTWARE	8,914	8,382	8,382	9,382	35,061
25	531411 - UA	NON-OPERATING SUPPLIES	425	425	425	425	1,700
26	532103 - UA	OUTSOURCED SERVICE - ACCOUNTIN					0
27	532104 - UA	OUTSOURCED SERVICES - OTHER					0
28	532105 - UA	OUTSOURCED SERVICE - CONSULTIN	25,000	23,000	25,000	20,000	93,000
29	552101 - UA	FREIGHT - INBOUND	75	75	75	75	300
30	552201 - UA	FREIGHT - OUTBOUND	150	150	150	150	600
31	591501 - UA	DEPRECIATION - EQUIPMENT	34,328	31,793	31,793	29,355	127,269
109							0
110							0
111							0
112							0
113							0
114							0
115							0
116							0
117							0
118							0
119							0
120							0
121							0
122	512001	DIRECT - SOCIAL SECURITY	0	0	0	0	0
123	512002	DIRECT - UNEMPLOYMENT INSURANC	0	0	0	0	0
124	512005	DIRECT - MEDICAL	0	0	0	0	0
125	512006	DIRECT - LIFE INSURANCE	0	0	0	0	0
126	512101	INDIRECT - SOCIAL SECURITY	7,419	7,592	7,592	7,592	30,195
127	512102	INDIRECT - UNEMPLOYMENT INSUR	1,545	1,545	1,545	1,545	6,180
128	512105	INDIRECT - MEDICAL	13,017	13,017	13,017	13,017	52,069
129	512106	INDIRECT - LIFE INSURANCE	894	894	894	894	3,575
130	512201	DIRECT - 401K	0	0	0	0	0
131	512301	INDIRECT - 401K	6,837	6,996	6,996	6,996	27,824
132		TOTAL	232,232	227,335	229,335	222,896	911,799
Budget

And consolidate into this

Excel Workbook
	A	B	C	D	E	F	G	H	I
2	UA	11111	503201	LABOR ABSORPTION	(128,262)	(120,008)	(109,641)	(111,789)	(469,700.00)
3	UA	11111	511001	SALARY & WAGE - DIRECT LABOR	96,674	90,453	66,112	67,406	320,645.50
4	UA	11111	511003	VACATION - DIRECT LABOR	2,913	10,196	14,727	12,462	40,298.16
5	UA	11111	511007	SAL&WAGE PREMIUM-DIRECT LABOR	4,394	4,112	3,005	3,064	14,574.80
6	UA	11111	511101	SALARY & WAGE - INDIRECT LABOR	15,521	15,987	15,987	15,987	63,481.02
7	UA	11111	511107	SAL&WAGE PREMIUM-INDIRECT LAB	1,000	1,000	1,000	1,000	4,000.00
8	UA	11111	531012	REPAIR & MAINTENANCE - MACH	250	250	250	250	1,000.00
9	UA	11111	531306	NON-CAPITALIZED TOOLS	800	800	800	800	3,200.00
10	UA	11111	531399	CHEMICAL - OPERATING SUPPLIES	3,000	3,000	3,000	3,000	12,000.00
11	UA	11111	531401	OPERATING SUPPLIES	3,000	3,000	3,000	3,000	12,000.00
12	UA	11111	531411	NON-OPERATING SUPPLIES	2,000	2,000	2,000	2,000	8,000.00
13	UA	11111	532104	OUTSOURCED SERVICES - OTHER	150	150	150	150	600.00
14	UA	11111	591101	DEPRECIATION - MACHINES	35,880	35,335	35,334	35,335	141,882.68
15	UA	11111	512001	DIRECT - SOCIAL SECURITY	7,955	8,014	6,414	6,344	28,727.16
16	UA	11111	512002	DIRECT - UNEMPLOYMENT INSURANC	2,781	2,781	2,163	2,163	9,887.20
17	UA	11111	512005	DIRECT - MEDICAL	23,431	23,431	18,224	18,224	83,309.65
18	UA	11111	512006	DIRECT - LIFE INSURANCE	1,609	1,609	1,251	1,251	5,720.00
19	UA	11111	512101	INDIRECT - SOCIAL SECURITY	1,264	1,299	1,299	1,299	5,162.30
20	UA	11111	512102	INDIRECT - UNEMPLOYMENT INSUR	309	309	309	309	1,235.90
21	UA	11111	512105	INDIRECT - MEDICAL	2,603	2,603	2,603	2,603	10,413.71
22	UA	11111	512106	INDIRECT - LIFE INSURANCE	179	179	179	179	715.00
23	UA	11111	512201	DIRECT - 401K	7,330	7,385	5,911	5,846	26,471.80
24	UA	11111	512301	INDIRECT - 401K	1,165	1,197	1,197	1,197	4,757.01
25	UA	11121	503201	LABOR ABSORPTION	(234,120.99)	(219,016)	(200,136)	(203,912)	(857,184.90)
26	UA	11121	511001	SALARY & WAGE - DIRECT LABOR	203,945.14	190,787	174,340	177,630	746,702.36
27	UA	11121	511003	VACATION - DIRECT LABOR	2,858.81	2,240	2,046	2,085	9,229.84
28	UA	11121	511007	SAL&WAGE PREMIUM-DIRECT LABOR	2,970.07	2,327	2,126	2,166	9,589.07
29	UA	11121	511101	SALARY & WAGE - INDIRECT LABOR	22,851.00	23,536	23,536	23,536	93,459.00
30	UA	11121	511107	SAL&WAGE PREMIUM-INDIRECT LAB	200.00	200	200	200	800.00
31	UA	11121	520001	TRAVEL EXPENSE - TRANSPORT AIR	500.00	500			1,000.00
32	UA	11121	520003	TRAVEL EXPENSE -ACCOMODATIONS	500.00	500			1,000.00
33	UA	11121	520004	TRAVEL EXPENSE -MEALS	250.00	250			500.00
34	UA	11121	531012	REPAIR & MAINTENANCE - MACH	350.00	350	350	350	1,400.00
35	UA	11121	531013	REPAIR & MAINTENANCE	1,000.00	1,000	1,000	1,000	4,000.00
36	UA	11121	531303	OFFICE SUPPLIES	50.00	50	50	50	200.00
37	UA	11121	531399	CHEMICAL - OPERATING SUPPLIES	1,000.00	1,000	1,000	1,000	4,000.00
38	UA	11121	531400	PAINT - OPERATING SUPPLIES	250.00	250	250	250	1,000.00
39	UA	11121	531401	OPERATING SUPPLIES	3,500.00	3,500	3,500	3,500	14,000.00
40	UA	11121	531404	OUTSIDE OPERATION EXPENSES	5,000.00	5,000	5,000	5,000	20,000.00
41	UA	11121	531411	NON-OPERATING SUPPLIES	2,500.00	2,500	2,500	2,500	10,000.00
42	UA	11121	552201	FREIGHT - OUTBOUND	500.00	500	500	500	2,000.00
43	UA	11121	591101	DEPRECIATION - MACHINES	29,439.00	29,439	29,439	29,057	117,374.00
44	UA	11121	512001	DIRECT - SOCIAL SECURITY	16,047.71	14,945	13,656	13,914	58,562.38
45	UA	11121	512002	DIRECT - UNEMPLOYMENT INSURANC	5,870.53	5,871	5,871	5,871	23,482.10
46	UA	11121	512005	DIRECT - MEDICAL	49,465.11	49,465	49,465	49,465	197,860.43
47	UA	11121	512006	DIRECT - LIFE INSURANCE	3,396.25	3,396	3,396	3,396	13,585.00
48	UA	11121	512101	INDIRECT - SOCIAL SECURITY	1,763.40	1,816	1,816	1,816	7,210.81
49	UA	11121	512102	INDIRECT - UNEMPLOYMENT INSUR	617.95	618	618	618	2,471.80
50	UA	11121	512105	INDIRECT - MEDICAL	5,206.85	5,207	5,207	5,207	20,827.41
51	UA	11121	512106	INDIRECT - LIFE INSURANCE	357.50	358	358	358	1,430.00
52	UA	11121	512201	DIRECT - 401K	14,787.81	13,771	12,584	12,822	53,964.66
53	UA	11121	512301	INDIRECT - 401K	1,624.96	1,673	1,673	1,673	6,644.69
54	UC	11123	502104	OTH NON-OH EXP - TAXES	750.00	750	750	750	3,000.00
Data

 

[Kim B]

That worked. So finally getting to see the whole picture, still some bugs. I noticed on dept 11121, it is duplicating and omitting. It duplicates once it gets down to acct 531411 and omits accts below 531411.

Here is the result:
Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Tahoma,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 129px"><COL style="WIDTH: 169px"><COL style="WIDTH: 241px"><COL style="WIDTH: 81px"><COL style="WIDTH: 141px"><COL style="WIDTH: 74px"><COL style="WIDTH: 81px"><COL style="WIDTH: 89px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">74</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>502022 - UA</TD><TD>CHANGES IN INVENTORY</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">75</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>502105 - UA</TD><TD>REWORK</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">76</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>503201 - UA</TD><TD>LABOR ABSORPTION</TD><TD style="TEXT-ALIGN: right">(234,121)</TD><TD style="TEXT-ALIGN: right">(219,016)</TD><TD style="TEXT-ALIGN: right">(200,136)</TD><TD style="TEXT-ALIGN: right">(203,912)</TD><TD style="TEXT-ALIGN: right">(857,185)</TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">77</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511001 - UA</TD><TD>SALARY & WAGE - DIRECT LABOR</TD><TD style="TEXT-ALIGN: right">203,945 </TD><TD style="TEXT-ALIGN: right">190,787 </TD><TD style="TEXT-ALIGN: right">174,340 </TD><TD style="TEXT-ALIGN: right">177,630 </TD><TD style="TEXT-ALIGN: right">746,702 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">78</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511003 - UA</TD><TD>VACATION - DIRECT LABOR</TD><TD style="TEXT-ALIGN: right">2,859 </TD><TD style="TEXT-ALIGN: right">2,240 </TD><TD style="TEXT-ALIGN: right">2,046 </TD><TD style="TEXT-ALIGN: right">2,085 </TD><TD style="TEXT-ALIGN: right">9,230 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">79</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511007 - UA</TD><TD>SAL&WAGE PREMIUM-DIRECT LABOR</TD><TD style="TEXT-ALIGN: right">2,970 </TD><TD style="TEXT-ALIGN: right">2,327 </TD><TD style="TEXT-ALIGN: right">2,126 </TD><TD style="TEXT-ALIGN: right">2,166 </TD><TD style="TEXT-ALIGN: right">9,589 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">80</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511101 - UA</TD><TD>SALARY & WAGE - INDIRECT LABOR</TD><TD style="TEXT-ALIGN: right">22,851 </TD><TD style="TEXT-ALIGN: right">23,536 </TD><TD style="TEXT-ALIGN: right">23,536 </TD><TD style="TEXT-ALIGN: right">23,536 </TD><TD style="TEXT-ALIGN: right">93,459 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">81</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511107 - UA</TD><TD>SAL&WAGE PREMIUM-INDIRECT LAB</TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">800 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">82</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>520001 - UA</TD><TD>TRAVEL EXPENSE - TRANSPORT AIR</TD><TD style="TEXT-ALIGN: right">500 </TD><TD style="TEXT-ALIGN: right">500 </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">83</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531012 - UA</TD><TD>REPAIR & MAINTENANCE - MACH</TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">1,400 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">84</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531013 - UA</TD><TD>REPAIR & MAINTENANCE</TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">4,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">85</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531091 - UA</TD><TD>COMMODITY - PPV</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">86</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531303 - UA</TD><TD>OFFICE SUPPLIES</TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">200 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">87</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531399 - UA</TD><TD>CHEMICAL - OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">4,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">88</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531400 - UA</TD><TD>PAINT - OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">89</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531401 - UA</TD><TD>OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">14,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">90</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531404 - UA</TD><TD>OUTSIDE OPERATION EXPENSES</TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">20,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">91</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531411 - UA</TD><TD>NON-OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">10,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">92</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>502022 - UA</TD><TD>CHANGES IN INVENTORY</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">93</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>502105 - UA</TD><TD>REWORK</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">94</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>503201 - UA</TD><TD>LABOR ABSORPTION</TD><TD style="TEXT-ALIGN: right">(234,121)</TD><TD style="TEXT-ALIGN: right">(219,016)</TD><TD style="TEXT-ALIGN: right">(200,136)</TD><TD style="TEXT-ALIGN: right">(203,912)</TD><TD style="TEXT-ALIGN: right">(857,185)</TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">95</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511001 - UA</TD><TD>SALARY & WAGE - DIRECT LABOR</TD><TD style="TEXT-ALIGN: right">203,945 </TD><TD style="TEXT-ALIGN: right">190,787 </TD><TD style="TEXT-ALIGN: right">174,340 </TD><TD style="TEXT-ALIGN: right">177,630 </TD><TD style="TEXT-ALIGN: right">746,702 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">96</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511003 - UA</TD><TD>VACATION - DIRECT LABOR</TD><TD style="TEXT-ALIGN: right">2,859 </TD><TD style="TEXT-ALIGN: right">2,240 </TD><TD style="TEXT-ALIGN: right">2,046 </TD><TD style="TEXT-ALIGN: right">2,085 </TD><TD style="TEXT-ALIGN: right">9,230 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">97</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511007 - UA</TD><TD>SAL&WAGE PREMIUM-DIRECT LABOR</TD><TD style="TEXT-ALIGN: right">2,970 </TD><TD style="TEXT-ALIGN: right">2,327 </TD><TD style="TEXT-ALIGN: right">2,126 </TD><TD style="TEXT-ALIGN: right">2,166 </TD><TD style="TEXT-ALIGN: right">9,589 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">98</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511101 - UA</TD><TD>SALARY & WAGE - INDIRECT LABOR</TD><TD style="TEXT-ALIGN: right">22,851 </TD><TD style="TEXT-ALIGN: right">23,536 </TD><TD style="TEXT-ALIGN: right">23,536 </TD><TD style="TEXT-ALIGN: right">23,536 </TD><TD style="TEXT-ALIGN: right">93,459 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">99</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>511107 - UA</TD><TD>SAL&WAGE PREMIUM-INDIRECT LAB</TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">200 </TD><TD style="TEXT-ALIGN: right">800 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">100</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>520001 - UA</TD><TD>TRAVEL EXPENSE - TRANSPORT AIR</TD><TD style="TEXT-ALIGN: right">500 </TD><TD style="TEXT-ALIGN: right">500 </TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">101</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531012 - UA</TD><TD>REPAIR & MAINTENANCE - MACH</TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">350 </TD><TD style="TEXT-ALIGN: right">1,400 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">102</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531013 - UA</TD><TD>REPAIR & MAINTENANCE</TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">4,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">103</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531091 - UA</TD><TD>COMMODITY - PPV</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">104</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531303 - UA</TD><TD>OFFICE SUPPLIES</TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">50 </TD><TD style="TEXT-ALIGN: right">200 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">105</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531399 - UA</TD><TD>CHEMICAL - OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">1,000 </TD><TD style="TEXT-ALIGN: right">4,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">106</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531400 - UA</TD><TD>PAINT - OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">250 </TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">107</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531401 - UA</TD><TD>OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">3,500 </TD><TD style="TEXT-ALIGN: right">14,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">108</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531404 - UA</TD><TD>OUTSIDE OPERATION EXPENSES</TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">5,000 </TD><TD style="TEXT-ALIGN: right">20,000 </TD></TR><TR style="HEIGHT: 16px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">109</TD><TD style="TEXT-ALIGN: right">11121</TD><TD>531411 - UA</TD><TD>NON-OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">2,500 </TD><TD style="TEXT-ALIGN: right">10,000 </TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4





Budget


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 79px"><COL style="WIDTH: 260px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="BACKGROUND-COLOR: #99ccff"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">DEPARTMENT: </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">11121</TD><TD style="BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">ASSEMBLY-QP</TD><TD style="BACKGROUND-COLOR: #99ccff"></TD><TD style="BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="BACKGROUND-COLOR: #99ccff"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">MANAGER: </TD><TD style="BACKGROUND-COLOR: #99ccff"></TD><TD style="BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">R SUMNER</TD><TD style="BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #99ccff"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">ACCOUNT</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">DESCRIPTION</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">Q1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">Q2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">Q3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">Q4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">2011</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD>502022 - UA</TD><TD>CHANGES IN INVENTORY</TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>502105 - UA</TD><TD>REWORK</TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>503201 - UA</TD><TD>LABOR ABSORPTION</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">(234,121)</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">(219,016)</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">(200,136)</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">(203,912)</TD><TD style="TEXT-ALIGN: right">(857,185)</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>511001 - UA</TD><TD>SALARY & WAGE - DIRECT LABOR</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">203,945 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">190,787 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">174,340 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">177,630 </TD><TD style="TEXT-ALIGN: right">746,702 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>511003 - UA</TD><TD>VACATION - DIRECT LABOR</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,859 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,240 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,046 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,085 </TD><TD style="TEXT-ALIGN: right">9,230 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD>511007 - UA</TD><TD>SAL&WAGE PREMIUM-DIRECT LABOR</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,970 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,327 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,126 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,166 </TD><TD style="TEXT-ALIGN: right">9,589 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD>511101 - UA</TD><TD>SALARY & WAGE - INDIRECT LABOR</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">22,851 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">23,536 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">23,536 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">23,536 </TD><TD style="TEXT-ALIGN: right">93,459 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD>511107 - UA</TD><TD>SAL&WAGE PREMIUM-INDIRECT LAB</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">200 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">200 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">200 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">200 </TD><TD style="TEXT-ALIGN: right">800 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD>520001 - UA</TD><TD>TRAVEL EXPENSE - TRANSPORT AIR</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD>531012 - UA</TD><TD>REPAIR & MAINTENANCE - MACH</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">350 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">350 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">350 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">350 </TD><TD style="TEXT-ALIGN: right">1,400 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD>531013 - UA</TD><TD>REPAIR & MAINTENANCE</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right">4,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD>531091 - UA</TD><TD>COMMODITY - PPV</TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD>531303 - UA</TD><TD>OFFICE SUPPLIES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">50 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">50 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">50 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">50 </TD><TD style="TEXT-ALIGN: right">200 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>531399 - UA</TD><TD>CHEMICAL - OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">1,000 </TD><TD style="TEXT-ALIGN: right">4,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD>531400 - UA</TD><TD>PAINT - OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">250 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">250 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">250 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">250 </TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD>531401 - UA</TD><TD>OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">3,500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">3,500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">3,500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">3,500 </TD><TD style="TEXT-ALIGN: right">14,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD>531404 - UA</TD><TD>OUTSIDE OPERATION EXPENSES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">5,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">5,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">5,000 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">5,000 </TD><TD style="TEXT-ALIGN: right">20,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD>531411 - UA</TD><TD>NON-OPERATING SUPPLIES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">2,500 </TD><TD style="TEXT-ALIGN: right">10,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD>532104 - UA</TD><TD>OUTSOURCED SERVICES - OTHER</TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD>541007 - UA</TD><TD>ADVERTISING - WEB SITE</TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">0 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD>552201 - UA</TD><TD>FREIGHT - OUTBOUND</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="TEXT-ALIGN: right">2,000 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD>591101 - UA</TD><TD>DEPRECIATION - MACHINES</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">29,439 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">29,439 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">29,439 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">29,057 </TD><TD style="TEXT-ALIGN: right">117,374 </TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD>520003 - UA</TD><TD>TRAVEL EXPENSE - ACCOMMODATION</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">500 </TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">1,000 </TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD>520004 - UA</TD><TD>TRAVEL EXPENSE - MEALS</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">250 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffff99">250 </TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="BACKGROUND-COLOR: #ffff99"></TD><TD style="TEXT-ALIGN: right">500 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: right">512001</TD><TD>DIRECT - SOCIAL SECURITY</TD><TD style="TEXT-ALIGN: right">16,048 </TD><TD style="TEXT-ALIGN: right">14,945 </TD><TD style="TEXT-ALIGN: right">13,656 </TD><TD style="TEXT-ALIGN: right">13,914 </TD><TD style="TEXT-ALIGN: right">58,562 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: right">512002</TD><TD>DIRECT - UNEMPLOYMENT INSURANC</TD><TD style="TEXT-ALIGN: right">5,871 </TD><TD style="TEXT-ALIGN: right">5,871 </TD><TD style="TEXT-ALIGN: right">5,871 </TD><TD style="TEXT-ALIGN: right">5,871 </TD><TD style="TEXT-ALIGN: right">23,482 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: right">512005</TD><TD>DIRECT - MEDICAL</TD><TD style="TEXT-ALIGN: right">49,465 </TD><TD style="TEXT-ALIGN: right">49,465 </TD><TD style="TEXT-ALIGN: right">49,465 </TD><TD style="TEXT-ALIGN: right">49,465 </TD><TD style="TEXT-ALIGN: right">197,860 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: right">512006</TD><TD>DIRECT - LIFE INSURANCE</TD><TD style="TEXT-ALIGN: right">3,396 </TD><TD style="TEXT-ALIGN: right">3,396 </TD><TD style="TEXT-ALIGN: right">3,396 </TD><TD style="TEXT-ALIGN: right">3,396 </TD><TD style="TEXT-ALIGN: right">13,585 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: right">512101</TD><TD>INDIRECT - SOCIAL SECURITY</TD><TD style="TEXT-ALIGN: right">1,763 </TD><TD style="TEXT-ALIGN: right">1,816 </TD><TD style="TEXT-ALIGN: right">1,816 </TD><TD style="TEXT-ALIGN: right">1,816 </TD><TD style="TEXT-ALIGN: right">7,211 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: right">512102</TD><TD>INDIRECT - UNEMPLOYMENT INSUR</TD><TD style="TEXT-ALIGN: right">618 </TD><TD style="TEXT-ALIGN: right">618 </TD><TD style="TEXT-ALIGN: right">618 </TD><TD style="TEXT-ALIGN: right">618 </TD><TD style="TEXT-ALIGN: right">2,472 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: right">512105</TD><TD>INDIRECT - MEDICAL</TD><TD style="TEXT-ALIGN: right">5,207 </TD><TD style="TEXT-ALIGN: right">5,207 </TD><TD style="TEXT-ALIGN: right">5,207 </TD><TD style="TEXT-ALIGN: right">5,207 </TD><TD style="TEXT-ALIGN: right">20,827 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: right">512106</TD><TD>INDIRECT - LIFE INSURANCE</TD><TD style="TEXT-ALIGN: right">358 </TD><TD style="TEXT-ALIGN: right">358 </TD><TD style="TEXT-ALIGN: right">358 </TD><TD style="TEXT-ALIGN: right">358 </TD><TD style="TEXT-ALIGN: right">1,430 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: right">512201</TD><TD>DIRECT - 401K</TD><TD style="TEXT-ALIGN: right">14,788 </TD><TD style="TEXT-ALIGN: right">13,771 </TD><TD style="TEXT-ALIGN: right">12,584 </TD><TD style="TEXT-ALIGN: right">12,822 </TD><TD style="TEXT-ALIGN: right">53,965 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: right">512301</TD><TD>INDIRECT - 401K</TD><TD style="TEXT-ALIGN: right">1,625 </TD><TD style="TEXT-ALIGN: right">1,673 </TD><TD style="TEXT-ALIGN: right">1,673 </TD><TD style="TEXT-ALIGN: right">1,673 </TD><TD style="TEXT-ALIGN: right">6,645 </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="BACKGROUND-COLOR: #99ccff"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">TOTAL</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">142,681 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">142,031 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">140,346 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">140,051 </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #99ccff; FONT-WEIGHT: bold">565,109 </TD></TR></TBODY></TABLE>





Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[GlennUK]

The definition of LastRow is wrong ... it's pointing at the wrong sheet. Correct that and see how it does.

 

[Kim B]

Run time error 438:

object doesn't support this property or method


Sub multicopy()
' get first file
fname = Dir("g:\accounting\private\msdacct\planning\2011\plan\budgets\budgets reviewed\*.xl*")
Do Until fname = ""
Workbooks.Open (fname)
Set fbook = ActiveWorkbook
Sheets("Budget").Select
lastrow = ActiveWorkbook.Sheets(3).Range("B65536").End(xlUp).Row
targetrow = ThisWorkbook.Sheets(1).Range("B65536").End(xlUp).Offset(1).Row
ActiveWorkbook.Sheets(3).Range("B9:H" & lastrow).Copy
ThisWorkbook.Activate
Sheets(1).Select
Range("B" & targetrow).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ThisWorkbook.Sheets(1).Range("A" & targetrow).Resize(lastrow - 9 + 1).Value = _
Application.CutCopyMode = False
fbook.Sheets(3).Range("D5").Value
fbook.Close savechanges:=False
fname = Dir
Loop
End Sub

I changed the lastrow command in green is what i changed.

 

[Kim B]

DONE!! This is the final code for anyone that has been trying to follow this.

Works like a charm. Thank for your time, patients and expertise.



Sub multicopy()
' get first file
fname = Dir("g:\accounting\private\msdacct\planning\2011\plan\budgets\budgets reviewed\*.xl*")
Do Until fname = ""
Application.DisplayAlerts = False
Workbooks.Open (fname)
Set fbook = ActiveWorkbook
Sheets("Budget").Select
lastrow = ActiveWorkbook.Sheets(3).Range("B65536").End(xlUp).Row
targetrow = ThisWorkbook.Sheets(1).Range("B65536").End(xlUp).Offset(1).Row
ActiveWorkbook.Sheets(3).Range("B9:H" & lastrow).Copy
ThisWorkbook.Activate
Sheets(1).Select
Range("B" & targetrow).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ThisWorkbook.Sheets(1).Range("A" & targetrow).Resize(lastrow - 9 + 1).Value = _
fbook.Sheets(3).Range("D5").Value
fbook.Close savechanges:=False
fname = Dir
Loop
End Sub