Define Print & View Areas

"Using the Report Manager add-in program, you can combine worksheets , views (a set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.), and scenarios (a named set of input values that you can substitute in a worksheet model.) into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time."

Create a report for printing

1. On the View menu, click Report Manager.
   
2. Click Add.
   
3. In the Report Name box, type a name for the report.
   
4. In the Sheet box, click the sheet you want to use for the first section of the report.
   
5. Do one of the following:
   
   • To use a view for the first section of the report, select the View check box, and then click the view in the View box.
     
   • To use a scenario for the first section of the report, select the Scenario check box, and then click the scenario in the Scenario box.
     
6. Click Add to enter the view or scenario as a section in the Sections in this Report box.
   
7. Repeat step 5 and 6 until you've created all of the sections you want in the report.
   
8. To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
   
9. To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
   

Edit a report for printing

1. On the View menu, click Report Manager.
   
2. In the Reports box, click the report you want to edit, and then click Edit.
   
3. Do one or more of the following:
   
   • To add a new section, click the sheet, view, and scenario you want under Section to Add, and then click Add.
     
   • To delete a section, click the section in the Sections in this report box, and then click Delete.
     
   • To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
     
   • To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
     
   Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Print a report

1. On the View menu, click Report Manager.
   
2. In the Reports box, click the report you want to print.
   
3. Click Print.
   
4. In the Copies box, type the number of copies you want to print.
   

Labels: Addins, Tips

How to use names in Excel

• How To Define Range Names
  
  
• How To Use Range Names
  
  
• Absolute And Relative Addressing
  
  
• The Context Of Names
  
  
• Special Names
  
  
• A Step Further: A Formula In A Defined Name
  
  
• Dynamic Names
  
  
• Passing Arguments To A Defined Name Formula
  
  
• Bugs in Excel's Name Object

Labels: Formulas, Functions, Tips

Things should to function

"Excel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be used the same way you would use SUM(), VLOOKUP, or other built-in Excel functions.
The Excel user who wishes to use advanced mathematics or perform text manipulation is often seriously disappointed by Excel's limited library of formulas and functions. A UDF is simply a function that you create yourself with VBA.

The following is a sample that is a good candidate for a UDF:

Function CtoF(Centigrade)
CtoF = Centigrade * 9 / 5 + 32
End Function

In the Worksheet you would enter something like:
=CtoF(A1)

Labels: Formulas, Functions, Tips

Count to 52

Sub YearWorkbook()
Dim iWeek As Integer
Dim sht As Variant
Application.ScreenUpdating = False
Worksheets.Add After:=Worksheets(Worksheets.Count), _
Count:=(52 - Worksheets.Count)
iWeek = 1
For Each sht In Worksheets
sht.Name = "Week " & Format(iWeek, "00")
iWeek = iWeek + 1
Next sht
Application.ScreenUpdating = True
End Sub

Labels: Formats, Macros, Tips

Sometimes we must go next door

Getting data from other sheets can be very easy: or it can be very hard, it all depends on what you need to do. This article looks at some of the ways you can get data from other sheets.

• The basics
  
• Using the Indirect function
  
• Back to the old school, XLM! (previous and next sheet)
  
• VBA user defined functions (previous and next sheet)
  
• Links

Labels: Reference, Tips

That was no font, that was my typeface

Words into Type

Stop Stealing Sheep & Find Out How Type Works

The Elements of Typographic Style

by Robert Bringhurst ISBN 0881791326

A font can be defined as a collection of characters with the same style and size. A typeface is the design of the characters regardless of size or style. The terms are used interchangeably today.

Labels: Fonts