MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Dim wbInput As Workbook Dim wsInputSource As Worksheet Dim sFileName As String On Error Resume Next ' OPEN THE REQUIRED WORKBOOK sFileName = Application.GetOpenFilename Set wbInput = Workbooks.Open(sFileName) ' TEST IF NEW BUSINESS Application.ScreenUpdating = False Set wsInputSource = wbInput.Sheets("Manchester") For r = 2 To 50 If wsInputSource.Cells(r, 2).Value = "N" Then If wsInputSource.Cells(r, 3) <> 0 Then wsInputSource.Cells(r, 4).value = "New" End If End If Next r ...etc etc....
|Multiple (nested?) IF statements with AND / please help - Too many arguments||8||42|
|Frequency distribution of horizontal data?||5||29|
|first name and last initial in excel||11||28|
|MS Excel Multi Sheet Formula||13||31|