Quote Originally Posted by deesh123
I have a sheet where I have data specific to each day in a separate column. 

Day 1  Day 2 
  A        X
  B        Y
  C        Z
I want to have another section on the same sheet that breaks down data specific to a day.
Day 1 Breakdown
[A] [A*2] [A*3]
[B] [B*2] [B*3]
[C] [C*2] [C*3]

OR

Day 2 Breakdown
[X] [X*2] [X*3]
[Y] [Y*2] [Y*3]
[Z] [Z*2] [Z*3]
Is there a way where I can have a single cell change whether Day 1 or Day 2 is broken down in my "breakdown section"?
There used to be, in very junior schools, a subject known as 'Reading and Comprehension' whereby a child could read the letters D O and G as d-o-g = dog and associate that with some furry little ball on 4 legs that runs, barks, bites, and pee's on the lawn.

I guess I must have failed that subject.

I cannot see two occurances of 'A' to relate to [A*2] [A*3] etc (nor to any other letter/day combination).

Is there some guide as to the criteria for inclusion on the second section?

---