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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.