Pls help me... since am not aware of macros and now i need to complete my work faster.
lets say i have a any content (text or numbers) in range A1:H10000 in sheet 1. There is only one "BOLD" value in sheet 1. I need to copy that bold value and paste in sheet 2 of same workbook in column E. It should copy and paste in column E of sheet 2 only if there is any content in the corresponding cell in the previous column D of sheet 2. if there is no content in column D then it should not paste in column E and it should be blank or empty. I dont want to retain the format.
Thanks in advance
lets say i have a any content (text or numbers) in range A1:H10000 in sheet 1. There is only one "BOLD" value in sheet 1. I need to copy that bold value and paste in sheet 2 of same workbook in column E. It should copy and paste in column E of sheet 2 only if there is any content in the corresponding cell in the previous column D of sheet 2. if there is no content in column D then it should not paste in column E and it should be blank or empty. I dont want to retain the format.
Thanks in advance