Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

I need to make a workbook that sorts data

Discussion in 'Information Technology' started by Barry Walker, Jul 28, 2006.

  1. Barry Walker

    Barry Walker
    Expand Collapse
    Guest

    Each month I have to download a spreadsheet containing many columns of
    information. When I save it, I normally do so as an excel document, then i
    spend time sorting it out for analysis. This is time consuming and i'm
    looking for a way of downloading into a spread sheet that automatically sorts
    it the way I want it to and deletes unwanted columns and then totals a
    particular column.

    The information needs to be sorted as follows. The spreadsheet comes up with
    a random list containing information on 3 companies. I want it to sort into
    company order so,

    Company 1
    Company3
    Company3
    Company 2
    Compamy 1
    Company 2

    Becomes

    Company 1
    Company 1

    Company 2
    Company 2

    Company 3
    Company 3

    It also needs to total a series of values corresponding the to company.

    It does not matter what this spreadsheet looks like so a simpler way could
    be for Excel to detect a particular company and total the values
    corresponding to the particular company and automatically imput them into a
    seperate box.

    Can anyone help?

    Kind Regards

    Barry
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News WWI Sikh Heroes Need To Be Remembered: Dr Atamjit Breaking News Sep 11, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Need some info regarding bibek wrt eating Sikh Rehat Maryada Jan 14, 2016
    Spiritual Why We Only Need To Pray For Naam Blogs Dec 20, 2015

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Barry Walker wrote:
    > Each month I have to download a spreadsheet containing many columns of
    > information. When I save it, I normally do so as an excel document,
    > then i spend time sorting it out for analysis. This is time consuming
    > and i'm looking for a way of downloading into a spread sheet that
    > automatically sorts it the way I want it to and deletes unwanted
    > columns and then totals a particular column.
    >

    ....
    > Barry


    Sorry. This is a newsgroup dedicated to questions about Access, the
    database program in Office Professional. It appears your question may not
    be related to these subjects. The Microsoft help system is not all that
    clear and may have misdirected you here.

    It is best to ask your questions in a newsgroup dedicated to the
    subject of your question. You should find people better able to address
    your problem there.
    http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


    Note: It is always best to indicate the name and version of any
    program(s) you may be using when asking a question and also indicate the
    operating system (like Windows XP or 98) when you ask a question.

    --
    Joseph Meehan

    Dia duit
     

Share This Page