Any and all help greatly appreciated!! This problem is driving me madder than a box of frogs!!
Column E has sequential numbers beginning cell E8 with value 1, E9 with value 2 etc with values increasing by 1 onward until cell E420.
Column I has descending values starting from cell I8 (value 2950) and getting smaller each row down until row E420
Cell C10 has a value of 5.
Cell C9 has a value of 3000.
I would like to find the vba equation that allows me to enter data in Column G, beginning in cell G8 all the way down to cell G420.
I need the equation to honor the following conditions:-
If Cells in Column E (starting cell E8 with value 1, E9 with value 2 etc) have values lower or equal to cell C10 (value 5) then enter value of cell C9 (value 3000) into Cells in column G beginning in cell G8.
If cells in Column E have a value greater than cell C10 (value of 5) then enter the value of column I beginning with value in cell I8. In this example Cell C13 would have the value of I8 and cell C14 would have the value of cell I9 all the way down until cell C420 has a value I415.
Many thanks,
Bookmarks