Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Project two - Diffrence Sheet
I have gotten though most of "Project Two" now without much help;
However, I am now stuck..Here is what I have. I have 4 worksheets, each representing a week in the month. On each sheet I have Rows with order numbers, and collumns with various products listed in them, For each product type ordered there is also a total of those products recived. I then have a place to list how many were ordered for each and then list the diffrences. Some what Like this : Order# Apples Pears Beans Carrots 455 5 5 4 3 898 3 4 5 5 234 6 7 1 0 Totals 14 16 10 8 Ordered 10 16 12 20 Diffrence +4 0 -2 -12 What I need to do is have a 5th sheet that will list all the diffrences. (Not listing any of the 0's) Such as this. Week Product Amount Notes -------------------------- week one Apples +4 Extra Shipped Beans -2 Bad Beans returned Carrots -12 Driver was a rabbit -------------------------- Week Two Etc... -------------------------- Week Three Etc... -------------------------- Week Four Etc... -------------------------- Month Total -10 Find New Supplier! I am looking for suggestions on the best way to handle Sheet 5 Totals. One thought : Create 4 Ranges (one for each sheet like Week1Diff ) Each time Data is changed (On Event), Check the Diffrence range for that sheet for anything not a 0 and update this infor somehow to sheet 5. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Project two - Diffrence Sheet
Hi Barry,
A lot dedends on how complicated our data really is, but your shuld be able to link to your summary sheet. Just put it in list form. To not show 0 totals you can use an if statment, =if(A1 = 0, "", A1), but you will still end up with the titles on the left in the summary sheet. Hope that helps. "Barry Wright" wrote: I have gotten though most of "Project Two" now without much help; However, I am now stuck..Here is what I have. I have 4 worksheets, each representing a week in the month. On each sheet I have Rows with order numbers, and collumns with various products listed in them, For each product type ordered there is also a total of those products recived. I then have a place to list how many were ordered for each and then list the diffrences. Some what Like this : Order# Apples Pears Beans Carrots 455 5 5 4 3 898 3 4 5 5 234 6 7 1 0 Totals 14 16 10 8 Ordered 10 16 12 20 Diffrence +4 0 -2 -12 What I need to do is have a 5th sheet that will list all the diffrences. (Not listing any of the 0's) Such as this. Week Product Amount Notes -------------------------- week one Apples +4 Extra Shipped Beans -2 Bad Beans returned Carrots -12 Driver was a rabbit -------------------------- Week Two Etc... -------------------------- Week Three Etc... -------------------------- Week Four Etc... -------------------------- Month Total -10 Find New Supplier! I am looking for suggestions on the best way to handle Sheet 5 Totals. One thought : Create 4 Ranges (one for each sheet like Week1Diff ) Each time Data is changed (On Event), Check the Diffrence range for that sheet for anything not a 0 and update this infor somehow to sheet 5. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Project two - Diffrence Sheet
It would be far simpler on sheet 5 to have every product and pick up the
total difference. You could use conditional formatting to hide the detail of zero rows, and even bring out large differences. -- HTH RP (remove nothere from the email address if mailing direct) "Barry Wright" wrote in message ... I have gotten though most of "Project Two" now without much help; However, I am now stuck..Here is what I have. I have 4 worksheets, each representing a week in the month. On each sheet I have Rows with order numbers, and collumns with various products listed in them, For each product type ordered there is also a total of those products recived. I then have a place to list how many were ordered for each and then list the diffrences. Some what Like this : Order# Apples Pears Beans Carrots 455 5 5 4 3 898 3 4 5 5 234 6 7 1 0 Totals 14 16 10 8 Ordered 10 16 12 20 Diffrence +4 0 -2 -12 What I need to do is have a 5th sheet that will list all the diffrences. (Not listing any of the 0's) Such as this. Week Product Amount Notes -------------------------- week one Apples +4 Extra Shipped Beans -2 Bad Beans returned Carrots -12 Driver was a rabbit -------------------------- Week Two Etc... -------------------------- Week Three Etc... -------------------------- Week Four Etc... -------------------------- Month Total -10 Find New Supplier! I am looking for suggestions on the best way to handle Sheet 5 Totals. One thought : Create 4 Ranges (one for each sheet like Week1Diff ) Each time Data is changed (On Event), Check the Diffrence range for that sheet for anything not a 0 and update this infor somehow to sheet 5. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to find diffrence in time | Excel Discussion (Misc queries) | |||
calculate the diffrence in cost | Excel Worksheet Functions | |||
.01 or .02 diffrence in computation | Excel Discussion (Misc queries) | |||
Project Two - Sheet Number | Excel Programming | |||
Deploying excel sheet with a VB project | Excel Programming |