I have been working on a job cost accounting workbook for a while now. Thanks to Daffodil11 and FDibbins for help in getting this book to where it is!
However I have run into trouble with getting down a formula that will basically copy the values entered into one column and post them into another column. This is simple enough by its self, the comlex part is that the copied column represents costs in a period of time. The populated column is called "Current Distribution", so this would have to be easily update-able everytime i have new values for a new period of time. The second step to this is that there is also a "previously distributed" column. I would like this to show values in the column to the left of the values that have been posted in the "current distribution" column (unless the current distribution is also the 1st distribution). The third step to this is to sum total everything to the left of the current distribution values (not including the current values) to get the total amount already distributed. These formulas will be used on the sheet named "Status Report". I will post a worksheet that doesnt have any values entered, but all the formulas will still be in the cells, however the "Status Report" sheet is an out put only sheet, but if you would like to remove the formulas in the "Draw" columns so that you can easily enter numbers into those columns without switching sheets then be my guest. I have a dual screen set up so its not an issue for me. So far what I am thinking is somehow referencing a "Draw" column above the value range in the "Current Distribution" column and having that be the condition on what values to populate. Then the "Previously Distributed" column would be equal to the "Current Distribution" minus 1 column. The "Total Distributed" would then be the "Previously Distributed" plus every column to the left stopping at the "Draw 1" column. I hope this makes sense.
Thank you!
Bookmarks