Copy with respect to Row Head

Hi everyone;

I have a query please.

I have Sheet1 and Sheet2
Sheet1 has Black Blue Red Green rows
Sheet2 has values for each color Black, Blue, Green and Red.

I want to past automatically Blacks' values before black headed cell.
Respectively Blue Green Red.


Can you please help me in this issue
This is a sample actual data is in millions which I want to manage.

Sample sheet is attacched

Are you want this?

Please Login or Register  to view this content.

Thanks ikboy;

I tried to run this code but it is not working

See; if I filter Sheet1 for black

and copy values under Black, from sheet2

and past these values on sheet1

These values should go against visible cell which are filtered for black
and same for blue, green, red

Thanks
Let me know if you have any further question

Try the attachment.

Dear Ikboy;

It works great. but kindly advise me how to prepare it on original sheet.
I am not such expert in Excel.

also can you suggest any function for this kindly?
Look forward for your reply.

Thanks

For VBA: Press Alt+F11 to open VBA editor, insert module then write your codes.
if functions I will try to use : hlookup , counta , offset , index

Right ikboy;
Thanks