BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 267
- Office Version
- 2016
- Platform
- Windows
Hopefully this makes sense, it doesn't sound possible to me.
I have a number of columns E through to JG. Every 2nd column has a number (of people required) in rows 11 through to 72, some are blank on purpose. Every other column number is a price for that number of people.
The number of people is usually a fraction like =156/1 or just the hard coded number like 0.00641.
Column JI is the total number of people (i.e. cell JI11 =E11+G11+I1+K11 etc.).
Column JI has to be a whole numbers.. can't have fractions of people.
Unfortunately I need to reduce the amount of people in some buildings/columns whilst at the same time keeping the total number of people (in column JI) a whole number. It would be great to be able to reduce the number of people in one column whilst the other columns automatically increased. Any idea how to do this? Right now none of the cells are linked so it's quite a manual process and I have several workbooks to complete in same manner.
I have a number of columns E through to JG. Every 2nd column has a number (of people required) in rows 11 through to 72, some are blank on purpose. Every other column number is a price for that number of people.
The number of people is usually a fraction like =156/1 or just the hard coded number like 0.00641.
Column JI is the total number of people (i.e. cell JI11 =E11+G11+I1+K11 etc.).
Column JI has to be a whole numbers.. can't have fractions of people.
Unfortunately I need to reduce the amount of people in some buildings/columns whilst at the same time keeping the total number of people (in column JI) a whole number. It would be great to be able to reduce the number of people in one column whilst the other columns automatically increased. Any idea how to do this? Right now none of the cells are linked so it's quite a manual process and I have several workbooks to complete in same manner.
