- Nov 21, 2005
I am building a spreadsheet that will help schedule our weekly production. One of the things I am doing is moving data from one worksheet to another in order to show how much production needs to be done on certain days. The question I have is how can I divide the production up between different cells evenly. ( For example: I am going to produce 90 units on a Monday and on my master schedule page (which has all the days of the week)for Monday I have a cell that has "90" in the cell. I am moving that 90 over to a sepate worksheet that has our production lines and who will be responsible for production. If I am gonna to run the same product units on two or three seperate production lines, how can that 90 be divided equally between three seperate cells? Any help will be greatly appreciated.