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?

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?

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?