Hi All,
How do i put a cell value into a cell when the range of cell contain a specfic text.
For example, in the sample below, i want to put the cell value (13/2/2014) into B3 when a range of cell contain (A) Sam.
Excel.jpg
Is it possible as well that i can copy the cell value (13/2/2014) to all fields in column B till it reaches TOM (A1) for example?
Please enlighten me.
Thanks
Bookmarks