Loading ...
Sorry, an error occurred while loading the content.

Re: Trained/Not Trained Report

Expand Messages
  • bnelson45
    Cool! Thanks
    Message 1 of 4 , Sep 17, 2009
    • 0 Attachment
      Cool! Thanks

      --- In scouter_t@yahoogroups.com, "Hotmail Rod" <owlelope@...> wrote:
      >
      > You can do automatic page breaks in Excel by doing the following:
      >
      > Inserting Automatic Page Breaks
      >
      > You can use the subtotal feature to add a page break after each change in a
      > sort key. For example, Sort your data by unit,last name, first name. Then
      > you can subtotal on unit and Excel will add a page break for each value. Use
      > menu option Data, Subtotals and choose the Page Break Between Groups option.
      >
      >
      >
      > Rod
      >
      > -----Original Message-----
      > From: scouter_t@yahoogroups.com [mailto:scouter_t@yahoogroups.com] On Behalf
      > Of spatula751
      > Sent: Thursday, September 17, 2009 8:55 AM
      > To: scouter_t@yahoogroups.com
      > Subject: [Scouter_T] Re: Trained/Not Trained Report
      >
      > Bill,
      >
      > I wish I had good news for you, but....
      >
      > No, there is no ScoutNet generated report out there that will tell you
      > trained/not trained by unit (like the detailed advancement report does).
      > All you can get is a trained report (or a not trained report) for the entire
      > district, entire council or for one unit. (note: each unit would talk
      > forever for your registrar to create! It would take less time to insert
      > page breaks from the file.)
      >
      > You will need to insert the page breaks. Excel can do it, by going up to
      > the insert menu -> page break. But you will need to insert each one.
      >
      > Yours in Scouting,
      > Brian Sutilla
      >
      >
      > --- In scouter_t@yahoogroups.com, "bnelson45" <bnelson45@> wrote:
      > >
      > > I would like to request a report to print out for each unit that would
      > tell the unit who in their unit is trained and who is not trained.
      > >
      > > Is such a report available without me having to insert page breaks in the
      > excel spreadsheet that I get for the entire district?
      > >
      > > If I have to insert the page breaks, anyone know an easy way to do it
      > without sorting and manually inserting them?
      > >
      > > Bill
      > >
      >
      >
      >
      >
      > ------------------------------------
      >
      > For subscription and delevery options send a message to:
      > scouter_t-help@yahoogroups.com
      >
      > Scouting The Net - http://www.ScoutingTheNet.com/Yahoo! Groups Links
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.