Macro to populate row with numbers
 

Hello there,

Please help! I need to populate the row J30:AA30 with numbers to be selected
as follows:

- The macro must read each column from left to right in the range J10:AA14.

- When it finds a value with an orange font colour, it must immediately go
to the next column and start working vertically downwards. (A column with an
orange digit is skipped).

- Where there is NO orange orange digit identified, it must take the value
in row 14 of the respective column to populate row J30 from left to right.

- When it has finished this routine, it must then take the values from
B31:F31 as the next values to further populate row J30.

Thanx once again for your help.

Regards

--
KCG