floating table?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have a spreadsheet that contains both quarterly and
annual data. I would like to give users the option of
inputing data annually or quarterly without overwriting
the formulas (so if the choose annual this year, next year
they can input data quarterly and the annual column will
yield a total for the year). I was thinking of creating a
combo box that makes the users select the input method(qtr
v annual) and linking all of the input cells to this
decision.
1. Is this feasible?
2. Is there anyway to create a "floating table" that
would sit on top of the spreadsheet so I would not have to
change the existing format?
Thanks! M
 
Why not use 3 tables.

Table 1 = quarterly data
Table 2 = annual data
neither of the above has formulas

Table 3 = results table
=if(cell in annual table <> "", cell in annual table, sum(quarterly cells))

Regards,
Tom Ogilvy
 
Back
Top