I hope this is explained clearly.
I have one workbook called Tasks with many columns of data, the relevant ones for this question being TaskID, Recurrence, StartDate and Complete and DateLastCompleted.
Right now, I update this workbook (to complete tasks) one record at a time by double-clicking the Complete column for the row, which runs a VBA subprocedure called Calc_Completed that looks at StartDate and Recurrence and asks me if I want to repeat from the startdate, or a date that I specify (i.e., did I finish it when planned, or on another date?).
I will have another unnamed workbook (that is exported from my task management app) that contains TaskID and DateCompleted.
I know that I can filter my Tasks workbook to show only those records that exist in my unnamed workbook with a completion date.
I also know that I can run VBA that updates each record in the filtered Tasks ... but is there a way to run VBA that RUNS my Calc_Completed subprocedure on each record and answers it not only with "use the date I specify," but also inputs that DateCompleted from the unnamed workbook as that "date that I specify?"
Is that clear as mud?
I have one workbook called Tasks with many columns of data, the relevant ones for this question being TaskID, Recurrence, StartDate and Complete and DateLastCompleted.
Right now, I update this workbook (to complete tasks) one record at a time by double-clicking the Complete column for the row, which runs a VBA subprocedure called Calc_Completed that looks at StartDate and Recurrence and asks me if I want to repeat from the startdate, or a date that I specify (i.e., did I finish it when planned, or on another date?).
I will have another unnamed workbook (that is exported from my task management app) that contains TaskID and DateCompleted.
I know that I can filter my Tasks workbook to show only those records that exist in my unnamed workbook with a completion date.
I also know that I can run VBA that updates each record in the filtered Tasks ... but is there a way to run VBA that RUNS my Calc_Completed subprocedure on each record and answers it not only with "use the date I specify," but also inputs that DateCompleted from the unnamed workbook as that "date that I specify?"
Is that clear as mud?
