copy and paste the value of a cell if any cell in a row is highlighted

[prasadyanz]

hello,
i need to copy the value of a cell in ( say column B ) to column X if any of the cell is highlighted in row 1,
like wise i need to move on to the next row until the empty row
please let me know
thanks in advance

 

[JackDanIce]

How is the cell highlighted in row 1? Are you looking for a macro to automate copying the cell value from column B to column X?