Microsoft Excel 2000 Help.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top