Forum Discussion
Excel Code trying to copy cell data from one sheet to another based on 2 criteria
Sheet "My Plan" Sheet "Tracker" I have several plans in external files that I have code for to select and import 1 to sheet "My Plan". I am using cell E6 as a named cell called PlanName and I sele...
Hi - Sorry for the delay - I was away.
I fixed the error however these 2 rows seem to be the problem. The values remain empty, hence when the update happens it fills with nothing.
baselineDate = wsPlan.Cells(i, "I").Value
percentComplete = wsPlan.Cells(i, "L").Value
stop
baselineDate = wsPlan.Cells(i, "I").Value
percentComplete = wsPlan.Cells(i, "L").Value
Add stop before these two line to see weather they are run or omitted.