Tharabai
09-27-2015, 08:33 AM
Hello Everyone,
I need to insert a row based on the cell value in column Q. If the cell value is KAA or MAA then a row to be inserted and fill the values.
I have a sheet with the column A to Q. For the inserted rows the values should be same as prior row for the columns A,B,C,D,G,L and for others the value to be filled from the data in the another sheet.
For the column E, the value should be Aux if the prior value is "cont". And Colum F should be filled from the data from sheet2 based on the value from Q, E. If the cell value in column Q is "KAA" and Column E is "Aux" then the value for that should be picked from Sheet2.
I need to insert a row based on the cell value in column Q. If the cell value is KAA or MAA then a row to be inserted and fill the values.
I have a sheet with the column A to Q. For the inserted rows the values should be same as prior row for the columns A,B,C,D,G,L and for others the value to be filled from the data in the another sheet.
For the column E, the value should be Aux if the prior value is "cont". And Colum F should be filled from the data from sheet2 based on the value from Q, E. If the cell value in column Q is "KAA" and Column E is "Aux" then the value for that should be picked from Sheet2.