What I can suggest is to Add an extra row above the drop downs and use an IF Statement to =IF(B4="YES",1,0) you can always hide the column, then you simulate copying the cell then select the home sheet and simulate using Paste Special and Values and Paste Special and Add. Which will then add the value to the total. Finally look to clear the YES from the cell.
Sampel code is below:
PHP Code:
Sub AddToTotals()
'This is a demo only for one cell if this works for you
'Then it needs to be worked on for all the other cells.
Sheets("Homes").Range("b3").Copy
Sheets("Group").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlAdd, SkipBlanks _
:=False, Transpose:=False
Sheets("Homes").Range("b4").ClearContents
End Sub
09-06-2017, 07:05 AM
Similar Threads
Simple Spread Sheet
Windows Vista 
Office 2007
Threaded Mode