Wondering if I could get some assistance. I have VBA that is comparing SourceData tab to Cost Tracker Budget Info tab to find the new project numbers on the SourceData tab and copy to the bottom of the Cost Tracker tab. My problem is that the VBA is copying all of the project numbers over the VBA is at the bottom of the SourceData module. When I tried to isolate the VBA and placed into Module1 the VBA errored on
Set findit = ws.Range("A4:a").Find(what:=ce.Value, lookat:=xlWhole)
. And I am not sure why.
Any assistance would be appreciated.