+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Ms Office 2007: Splitting an Excel spreadsheet into many sheets in Technical; Posted this also in the How to do it section but hoping I'll get a response here in the proper ...
  1. #1

    Join Date
    Mar 2007
    Posts
    383
    Thank Post
    21
    Thanked 4 Times in 4 Posts
    Rep Power
    17

    Ms Office 2007: Splitting an Excel spreadsheet into many sheets

    Posted this also in the How to do it section but hoping I'll get a response here in the proper place!

    The accounts dept here have asked would I have a solution for them to make their petty cash summary a bit easier to maintain. At present everything goes into 1 big Excel spreadsheet & this as you can imagine gets very big during the term.

    I was wondering if there was a way of taking 1 large Excel spreadsheet (essentially, where the data is inputted initially) which then splits it into other sheets based on the Dept / Category name ... ie. Art dept expenses are in a separate sheet from Admin dept etc.

    The only way I've found so far is to manually put the data into individual depts then have it referencing back to a summary sheet but they would rather put data into a summary page first.

    I'm considering designing a MySQL database with a PHP front end to make this work - as I know it's definitely possible within that.

    Thanks in advance!

  2. #2

    Join Date
    Oct 2013
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi Steve,
    Here's link to a VBA script which takes stuff from a Master sheet and pastes it into individual sheets based on the value in a particular column (in your case you'd use the column listing your Departments);
    Sheet1 to WBs - Jerry Beaucaire's - Excel Assistant

    The script was written by Jerry Beaucaire, so, as you'd expect, does exactly what it says on the tin with a minimum of fuss.

    You might need to re-arrange your data a bit to make it work. But once you've done that I find it works like a dream.

    Cheers,
    Richard



SHARE:
+ Post New Thread

Similar Threads

  1. Splitting an Excel spreadsheet into many sheets
    By SteveB_NI in forum How do you do....it?
    Replies: 0
    Last Post: 19th September 2013, 05:14 PM
  2. [MS Office - 2007] Running MS Office 2003 and MS Office 2007 on the same network.
    By Richard_Finnigan in forum Office Software
    Replies: 2
    Last Post: 19th June 2009, 12:28 PM
  3. MS Office 2007 Compatibility SP2
    By Chuckster in forum Windows
    Replies: 1
    Last Post: 19th May 2009, 12:35 PM
  4. MS Office 2007. Word Spell Check
    By sLiDeR in forum Office Software
    Replies: 1
    Last Post: 4th March 2009, 01:11 AM
  5. MS Office 2007 default 2003 format save
    By zag in forum Educational Software
    Replies: 4
    Last Post: 24th April 2007, 11:44 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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