I need a formula to equally divide a number from column A across a variable number of cells ( could be any number of cells from from 1 to 52). The starting column could also be variable from Column B to Column ZZ, and the ending column could be the same as the starting column and go as far as column ZZ.
The tricky part is I'd like to be able to manually override any specific cell(s) by entering a number, and have all other cells in the row adjust to any manual entry(ies) so the sum total always is equal to Column A.
The spreadsheet is being used for time management on a weekly basis for up to a year. Individual employees might only have 5 or so rows in the Time Management Plan or 20 or more rows depending on how many Project Items they are working on. The formulas will be used as part of a larger spreadsheet including recurring meetings and logistical/management time in order to address employee capacity for resourcing new work items projected over the upcoming year.
The tricky part is I'd like to be able to manually override any specific cell(s) by entering a number, and have all other cells in the row adjust to any manual entry(ies) so the sum total always is equal to Column A.
The spreadsheet is being used for time management on a weekly basis for up to a year. Individual employees might only have 5 or so rows in the Time Management Plan or 20 or more rows depending on how many Project Items they are working on. The formulas will be used as part of a larger spreadsheet including recurring meetings and logistical/management time in order to address employee capacity for resourcing new work items projected over the upcoming year.
