Page 4 of 4 FirstFirst 1234
Results 46 to 49 of 49

Thread: Looking for advice with section cash and accounts

  1. #46
    Senior Member
    Join Date
    Nov 2013
    Posts
    458
    Thanks
    352
    Thanked 310 Times in 155 Posts
    Quote Originally Posted by ASLChris View Post
    Why would you use "interesting" formula here when pivot tables will do the job?
    Because pivot tables are not enough, especially if you want to have full control over the layout and combine data from multiple queries on the same page.

    We of course use pivot tables for all sorts of add hock reporting.

  2. #47
    Senior Member
    Join Date
    Nov 2013
    Posts
    458
    Thanks
    352
    Thanked 310 Times in 155 Posts
    Quote Originally Posted by dralphs View Post
    I program a little and know my way around Excel and "know a man who can" for more advanced stuff so will take a look at your system.
    Any chance of you sharing your spreadsheet as a pointer?
    I have PM'd you a link.

  3. The Following User Says Thank You to hippysurfer For This Useful Post:

    dralphs (30-07-2019)

  4. #48
    The unpaid help ASLChris's Avatar
    Join Date
    Jan 2009
    Posts
    5,266
    Thanks
    921
    Thanked 636 Times in 424 Posts
    Quote Originally Posted by hippysurfer View Post
    Because pivot tables are not enough, especially if you want to have full control over the layout and combine data from multiple queries on the same page.

    We of course use pivot tables for all sorts of add hock reporting.
    I pivot the data and point a = from my layout. Which is a far more auditable and less complex way to do it.
    Chris Hawes, District Media Manager, Watford North Scout District and Watford Scouts; Group Treasurer and Webmaster, 9th North Watford Scout Group.
    Web designer of free Scouting templates, Scouting Themes 4 WordPress.

    Social media
    Twitter: @WNScouts / @9NWScouts
    Facebook: /WNScouts
    Instagram: @WNScouts

  5. #49
    Member
    Join Date
    May 2005
    Location
    Oxford
    Posts
    94
    Thanks
    120
    Thanked 15 Times in 14 Posts
    Thanks all especially hippysurfer for the sample spreadsheet.
    A lot to consider and will review suggestions over next couple of weeks.
    Dave Ralphs
    Yarnton Scout Group (Treasurer)
    DofE Advisor & District Exec Member - Oxford Spires District
    http://yarntonscouts.org.uk/

  6. The Following User Says Thank You to dralphs For This Useful Post:

    hippysurfer (31-07-2019)

Similar Threads

  1. Replies: 16
    Last Post: 23-01-2019, 06:07 AM
  2. Advice needed regarding Cubs section.
    By SimbaUK in forum Scouting Talk
    Replies: 17
    Last Post: 03-05-2015, 10:00 PM
  3. Cash's
    By scarlet pimp in forum Scouting Talk
    Replies: 20
    Last Post: 15-03-2014, 08:49 AM
  4. GNU Cash
    By fmountford in forum Scouting Talk
    Replies: 7
    Last Post: 21-02-2011, 01:46 PM
  5. Section Accounts
    By Nigel in forum Scouting Talk
    Replies: 33
    Last Post: 01-10-2009, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •