Hello,
I would like to ask a simple question.
I would like to link colors from cell range 'Sheet x'!B2:B15 to Sheet2!K2:K15 and colors from cell range 'Sheet x'!C2:C15 to Sheet2!T2:T15
I have over 30 such transformation and is very time consuming. I am sure this task could be automated by VBA quite simple, but it is currently beyond my capability...
Thanks,
Thomas
I would like to ask a simple question.
I would like to link colors from cell range 'Sheet x'!B2:B15 to Sheet2!K2:K15 and colors from cell range 'Sheet x'!C2:C15 to Sheet2!T2:T15
I have over 30 such transformation and is very time consuming. I am sure this task could be automated by VBA quite simple, but it is currently beyond my capability...
Thanks,
Thomas