1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Microsoft Excel 2000 Help.

Discussion in 'Business Applications' started by justice_boy, Sep 17, 2003.

Thread Status:
Not open for further replies.
  1. justice_boy

    justice_boy Thread Starter

    Joined:
    Aug 26, 2003
    Messages:
    5
    Hi People,

    I seem to be having some trouble with grouping data.

    For Example I have the following Data source in my spreadsheet:

    Cutomer Name Type Tax/No A/B Total KG $/KG Total
    David Dust I No B 10 350 3500
    David Dust II Tax A 19 100 1900
    David Dust II Tax A 20 200 4000
    Jenny Ash I No B 12 120 1440
    Jenny Ash I Tax A 10 100 1000
    Etc....

    Now I want to format the data source in a new spread sheet by linking values so it would look like this:

    Part A :
    Name Tax-KG Tax-$/KG No-KG No-$/KG
    David 39 300 10 350
    Jenny 10 100 12 120

    Part B:
    Name %KG KG Avg Total %Total
    David 0.69 49 191.83 9400 0.79
    Jenny 0.31 22 110.9 2440 0.21

    Part C:
    Type Tax-KG Tax-Total No-KG No-Total
    Dust I 10 3500
    Dust II 39 5900
    Ash I 10 1000 12 1440

    Now the biggest problem is I want Part A & B & C to fill those data automatically when I entered the data at the data source worksheet (So i dont have to highlight the data range manually everytime there is a new data I want to enter). Is this a feasible thing in Excel?

    Thank you in advance.
     
  2. Bruce319

    Bruce319

    Joined:
    May 14, 2003
    Messages:
    379
    If you like to use a new tabsheet within the same file for your spreadsheet, all you have to do on the new spreadsheet is enter the = sign in the cell you want a particular information to show up, then move to the original cell with the data and click on it. Once clicked, press enter and your done. So everytime you make changes to the original cell, the changes will also be made on the cell that contains the = sign.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/165372

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice