Place "X" in a cell based on tonnes across columns "weeks"
I currently have a worksheet that places an "X" in a cell across columns based on a frequency of weeks, so if the job is forecast to be two weekly then a X is placed every two weeks. This works.
I am now trying to change this for some so that it calculates based on tonnes that is able to be changed depending on how many tonnes are forecast.
1. When frequency works on weeks a "X" is placed in the cell across the columns. Column "I" is the frequency weeks
2. Trying to get a "X" placed in a cell when based on tonnes in rows 19 & 20. Column "J" is the column for tonnes.
3. Has to use the budget tonnes "AK23" as a rule, so calculates the amount of tonnes per week against budget tonnes and places a "X" in cell across rows. This counts down across columns based on budget tonnes entered.
So based on cell "J3" 75000 tonnes equals 1 week. Now I am budgeting the first month July-15 is going to be 180000 tonnes, because this is lower then originally forecast I want the 2 weekly check to extend further. The budget tonnes would have to keep adding across line 23 as the months go by.
Thanks for any help
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By excelteam777 in forum Excel Formulas & Functions
Last Post: 06-07-2015, 11:24 AM
By chris_d in forum Excel General
Last Post: 03-23-2015, 06:19 PM
By krjoshi in forum Excel Programming / VBA / Macros
Last Post: 03-17-2014, 02:11 PM
By Jokeman in forum Excel Formulas & Functions
Last Post: 11-17-2013, 12:05 PM
By austin123456 in forum Excel Programming / VBA / Macros
Last Post: 10-09-2013, 06:14 AM
By sy_lavery in forum Excel General
Last Post: 01-09-2013, 06:52 PM
By ccowman in forum Excel Formulas & Functions
Last Post: 12-14-2012, 02:33 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1