Hi all!
I am having difficulty with a workbook and hoping to get some help. On this current workbook each line is for a different question and depending on how it is answered will assign either 5 points or 0 points and also turn the Comment column either green or red. On the corrective action plan each line is simply just transferred to that tab using a =Inspections!xx formula. I am looking for two things here. The first is I only want the lines that have 0 points (red cells) to transfer to the corrective action tab. This will eliminate the need to filter on cell color. The second is I want for when i enter a completed date in column G of the corrective action plan it automatically increase the score of the line to 5 and adjust the value on the Inspections tab. Appreciate any help on this!
I am having difficulty with a workbook and hoping to get some help. On this current workbook each line is for a different question and depending on how it is answered will assign either 5 points or 0 points and also turn the Comment column either green or red. On the corrective action plan each line is simply just transferred to that tab using a =Inspections!xx formula. I am looking for two things here. The first is I only want the lines that have 0 points (red cells) to transfer to the corrective action tab. This will eliminate the need to filter on cell color. The second is I want for when i enter a completed date in column G of the corrective action plan it automatically increase the score of the line to 5 and adjust the value on the Inspections tab. Appreciate any help on this!
