Please refer to the spreadsheet that is attached “GQ Spreadsheet.xlsx” when reading this problem statement.
The cells in row 3, the green fill color is RGB(153,255,51)
The cells in row 4, the yellow fill color is RGB(255,255,0)
- In this screen shot the TEXT in the 1st green cell is
"GQ-005 - Approval Time"
and the next green cell has
"GQ-008 - GMP Certificate"
In the area BETWEEN the cells
that have the green RGB(153,255,51), in this case Columns D to W...
I want to copy the value in column "E" (Not Applicable) to column "A"
Then copy the value in column "O" (3 Months) to column "A" (appended)
that the column data that gets appended has the word "Regulatory" in the header with the yellow fill color.
that there is a third occurrence of "Regulatory", the data in that column contains "3 Months" which has already been appended, there should be no duplicate data that gets appended.
Hopefully this is clear. If not please ask any questions you may have.
Thanks for your help in advance.