anbarasi_r
05-27-2015, 01:40 PM
I'm looking for a code in certain columns which copies a text to adjacent cells based on a cell value. If a cell in column contains the desired text then 3 adjacent cells to the left of column should also contain the same text
Attaching my sheet here 13533
If you look at the sheet, Column I, M, Q, U needs to be checked for "Dismissed". If any cell contains dismissed the 4 adjacent cells to left also need to contain "dismissed"
eg: if M6 is found to contain "Dismissed" then the same needs to be copied to cells J6, K6 and L6
Any help is appreciated.
Thanks in advance
Attaching my sheet here 13533
If you look at the sheet, Column I, M, Q, U needs to be checked for "Dismissed". If any cell contains dismissed the 4 adjacent cells to left also need to contain "dismissed"
eg: if M6 is found to contain "Dismissed" then the same needs to be copied to cells J6, K6 and L6
Any help is appreciated.
Thanks in advance