Kudos Received

8/30/11 Tom McCabe

Amy, sorry my flight was late and could not review. But I would not jhave changed a thing. Perfect presentation and more importantly, perfect facilitation today. Thank you for the professional competence you showed today in leading the team through your very complex and challenging ares. I think youmade a huge difference I'm making the workshop a resounding success. Got nothing but positive feedback from some newly opened eyes!

VR,

Tommy

12/10/10 Wayne Gibbons

Amy….my sincere thanks for your level of support to this office over these past five weeks.  Your daily coordination with our govt. counterparts and this office in coming to successful closure on a multitude of contract mods for both MTSS and SCETC/ATG has been no small task.     Compounding the timely execution of the contract mods was  my short tenure here and the absence of our operations officer.  In spite of these personnel handicaps, I believe we were successful in meeting govt. requirements…….due in large measure to your support.  Again, thanks!

Wayne

11/21/10 Jim Hawn

Just wanted to tell you that Amy has been doing heroic work on the ATG contract, dealing with all the changes and many frustrations as we've gone through this process.  Well deserving of some kudos from above.

Jim

Headers in Excel

Notes on how to set up "dynamic" headers in Excel so you can update the variable data within a worksheet and through running a Macro will then update in each page header.  This allows you to avoid having to update the header data individually on each worksheet.

-------

DO NOT RENAME THIS WORKSHEET TAB - IT MUST BE "Sheet4"

 

Information to include in cell A3:  "Proposal Dated: 21 November 2011"  Note, this RightHeader information MUST remain in cell A3

 

To insert this information into your header:

1) SAVE your file

2) SAVE AS a new revision (note, you must select "Save as type" as "Excel Macro-Enabled Workbook")

*These two steps are important because this "header process" is done by MACRO

There is no way to UNDO a MACRO once it has been run             

You can overright the information by changing the text in cell A3 and then rerunning the MACRO            

But, if something goes amiss and messes up all the other page formatting you will be very upset that you skipped these two steps, I promise.

3) Click on the "Developer" tab

4) Click on the "Macros" button

5) Select:

"ThisWorkbook.PrintReport"

6) Click "Run"

Note, if your Developer tab isn't showing:

Right click on any other tab (ie Page Layout)

Select "Customize the Ribbon"

On the right side of the window, make sure the check box beside "Developer" is checked           

 

The macro code should be added to "ThisWorkbook" under the "Genaral" tab as a "Print Report" and is written as follows:

 

Sub PrintReport()

    Dim wks As Worksheet

    Dim ftr

    ftr = Sheet4.Range("A3").Value

    For Each wks In Worksheets

        With wks.PageSetup

            .RightHeader = "&""Times New Roman,Italic""" & ftr

        End With

    Next wks

End Sub