Hi anyone,
How could I write a sum up formula that would apply for the following purpose. Suppose;
The user types January in cell AA9 and 2011 in cell AH9; I want the formula to copy all the fruits that has been sold to all the "OUT" customers (from column L of the sheet "Mysheet") to get copied to the cells of the steet "stat" starting from "D11" to AI11 and fruits sold to all the IN customers to get copied to the cells starting from "D12" to "AI12" of the same sheet.
And when the user selects another month like February or any other month, all the data related to February to get copied to the above mentioned cells.
I hope I've made my question clear.
Any help would be kindly appreciated.
How could I write a sum up formula that would apply for the following purpose. Suppose;
The user types January in cell AA9 and 2011 in cell AH9; I want the formula to copy all the fruits that has been sold to all the "OUT" customers (from column L of the sheet "Mysheet") to get copied to the cells of the steet "stat" starting from "D11" to AI11 and fruits sold to all the IN customers to get copied to the cells starting from "D12" to "AI12" of the same sheet.
And when the user selects another month like February or any other month, all the data related to February to get copied to the above mentioned cells.
I hope I've made my question clear.
Any help would be kindly appreciated.