I have a sheet where I have data specific to each day in a separate column.
I want to have another section on the same sheet that breaks down data specific to a day.![]()
Day 1 Day 2 A X B Y C Z
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"?![]()
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]
Bookmarks