Plugs
I have been taught to "close" financial statements using plugs. I think this is a lazy way to do it. Is there an alternative to this tricky solution? Thanks for your answer.

INDEX vs CHOOSE
Is there any reason to avoid using INDEX in a model? It's working out great for me in model but I'm cautious since I haven't used it before.

Re: Complex Trading Comps Analysis
Here is part of the note to consolidated financial statements from income tax section: "The effective income tax rate on earnings was 31.4% in fiscal 2005, 37% in fiscal 2004, and 37.8% in fiscal 2003. The decrease in the effective income tax rate in fiscal 2005 from fiscal 2004 is primarily... Here is part of the note to consolidated financial statements from income tax section:

"The effective income tax rate on earnings was 31.4% in fiscal 2005, 37% in fiscal 2004, and 37.8% in fiscal 2003. The decrease in the effective
income tax rate in fiscal 2005 from fiscal 2004 is primarily attributable to a $54,155 income tax benefit resulting from the settlement of a
transfer pricing dispute between the United States and Canada (covering the years 1996-2003) and a net tax benefit on unremitted foreign
earnings of $20,592. The Company recognized a tax benefit of $30,602, resulting from excess foreign tax credits on unremitted foreign
earnings and recognized a tax expense of $10,010, resulting from tax expense on translation gains accumulated to the date that the Company
determined that certain unremitted foreign earnings were no longer permanently reinvested. The net benefit of $20,592 relates to that portion of
unremitted foreign earnings that the Company plans to repatriate in the foreseeable future. Excluding these benefits the effective income tax
rate on earnings in fiscal 2005 was 36.2%.

For the fourth quarter of fiscal 2005 and 2004, the effective tax rate was 28.9% and 37.0%, respectively. The decrease in the fourth quarter tax
rate for fiscal 2005 is primarily attributable to a net tax benefit of $20,592, as noted above, and a tax benefit of $13,895 primarily associated
with lower state taxes. The state tax benefit recorded in the fourth quarter was primarily due to a reduction in the estimated effective state tax
rate utilized in the first through third quarters of fiscal 2005. Excluding the benefit of these two items, the fourth quarter tax rate for fiscal 2005
would be 35.8%. "

Should we adjust the $13,895? Read More

Macro formatting question
Hey, is it possible to change the macro you have for %, so that negative and positive %'s would align with one another? Is there a way I could do that or you could? Also, is there a way to get rid of the space between $ #,### format. I would rather have if $#,###.

Printing
How do a write a macro to print the entire worksheet except for page one and the last page. Each time I print, there will be a different number of pags so this needs to adjust as I add / delete tabs.