K
KCG
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
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