Can someone help me with ".find" without using select? I'm switching between multiple workbooks to get a summary of the data. How can I select the DT workbook, unprotect the sheet, and find the correct worker (from variable) and copy it? Then select the next workbook (where the summarized data goes) and paste the data?
'Copies the DT hours and pastes in the Hours workbook wkDT.Activate Sheets("Labor").Unprotect Sheets("Labor").Select Range("B3").Activate Cells.Find(What:=wrkr, After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, searchorder:=xlByRows, MatchCase:=False).Activate ActiveCell.Offset(32, 0).Select Selection.Copy 'pastes the values into the new sheet wK1.Activate Sheets("Hours").Select Cells(lastRow, 4).PasteSpecial xlPasteValues