I was get a vba sample code that update sheets from master sheet after flirting data but I was found that it create a sheets which I don’t need it and my question is could any one help me to modify this code to update the exist worksheets only and ignore the rest
Thanks in advance
Ahmed
Her is the code:
'check for individual worksheets
For Each myCell In ListRange.Cells
If WksExists(myCell.Value) = False Then
Set wks = Sheets.Add
On Error Resume Next
wks.Name = myCell.Value
If Err.Number <> 0 Then
MsgBox "Please rename: " & wks.Name
Err.Clear
End If
On Error GoTo 0
wks.Move After:=Sheets(Sheets.Count)
Else
Set wks = Worksheets(myCell.Value)
wks.Cells.Clear
End If
If rsp = 6 Then
DataBaseWks.Rows("1:" & i).Copy Destination:=wks.Range("A10")
End If
Bookmarks