hi,

i would like to change a number of worksheets names if there is data in a cell.

ie . if A4 to N4 had data in them then change the worksheets names to the values in the cell 2 above them

for example a4 had blue in it. a2 has "colour" in it, a4 has 48 in it a2 has house no in it

i need to changa the worksheet names to suit the data in the row 2 if there is data in the row 4


thank
you