C
CMarkou
I created a workbook containing 31 worksheets for each day of the month,
then a final worksheet containing the gains or losses of each day with
a final gain or loss for the month. I have formulas doing basic
calculations +, -, ect. The results are then transferred to the next
worksheet for the opening numbers. How do I NOT show the numbers for
the days that there are no numbers input yet. Given example:
Day 1 1000
Received 100
Total 1100
Sales 500
Book Total 600
Actual total 450
Gain or loss-150
Day 2 Not being started yet
Day 2 450
Received 0
Total 450
Sales 0
Book Total 450
Actual total 0
Gain or loss -450 I want to make this not show up till work is
input.
Totals sheet Will now also show the same thing a loss for the day and
in the final column it will show a loss of -450 can I make this only
show what days are complete also
then a final worksheet containing the gains or losses of each day with
a final gain or loss for the month. I have formulas doing basic
calculations +, -, ect. The results are then transferred to the next
worksheet for the opening numbers. How do I NOT show the numbers for
the days that there are no numbers input yet. Given example:
Day 1 1000
Received 100
Total 1100
Sales 500
Book Total 600
Actual total 450
Gain or loss-150
Day 2 Not being started yet
Day 2 450
Received 0
Total 450
Sales 0
Book Total 450
Actual total 0
Gain or loss -450 I want to make this not show up till work is
input.
Totals sheet Will now also show the same thing a loss for the day and
in the final column it will show a loss of -450 can I make this only
show what days are complete also