Copy range if range>0
Posted on 2012-03-31
Once again I turn to you for your expert help. I need to have my worksheet populate values from another worksheet if the Range.Value >0 and to add a "+" character in front of the value.
I will always be working in the same workbook.
Sheet2 is destination worksheet
Sheet1 is source worksheet
There are 23 Lines to calculate
The formulas are as such:
Sheet2.Range("L7") = Sheet1.Range(K5+K7+K8)
Sheet2.Range("L8") = Sheet1.Range(M5+M7+M8)
Sheet2.Range("L9") = Sheet1.Range(O5+O7+O8)
...... continues on for a total of 23 lines of data
Sheet2 is Column L (12) + (row 7 to 29)
Sheet1 has variable columns that increase by 2. Starting at Column K (11) then + 2 for the next.
Sheet 1 will always be rows 5, 7, 8 for the calculation.
I am having issues trying to estabish the Range.Cells equation to get this to populate correctly. Then the issue if Sheet1.Range.Value = 0 then it does nothing, or if Sheet1.Range.value>0 then character "+" followed by the total of Sheet1.Range.value.
I hope explained myself correctly. If you need additional information - please let me know.