Windows 2007 excel
Worksheet “Project Tracking” - cell AK7 when the cell has the text word “Awarded” I would like the data from row 7 column “C” through column “I” to be copied and pasted to worksheet “BD – Estimating Schedule” find last row and paste from column “C” through Column “I”
In Worksheet “Project Tracking” cell AK8 when the cell text says “Awarded” again find the last row on worksheet “BD – Estimating Schedule” and past. And so on down the AK column.
I want to be able to control this function with each row individually when column AK (whatever row) cell has the text “Awarded” in it.
I tried a command button but could not get it to work.
Worksheet “Project Tracking” - cell AK7 when the cell has the text word “Awarded” I would like the data from row 7 column “C” through column “I” to be copied and pasted to worksheet “BD – Estimating Schedule” find last row and paste from column “C” through Column “I”
In Worksheet “Project Tracking” cell AK8 when the cell text says “Awarded” again find the last row on worksheet “BD – Estimating Schedule” and past. And so on down the AK column.
I want to be able to control this function with each row individually when column AK (whatever row) cell has the text “Awarded” in it.
I tried a command button but could not get it to work.