Insert and highlight cell when intersect

[airbatucampur92]

By using VBA, how can i insert and highlight cell if it meets the condition like example that i attached in file below.

the situation is:
1)if 'process' in sheet 1 is equal/contain with the process in sheet 2, copy 'title' to the empty cell according to months and year
2)after insert to suitable cell, the cell will be highlighted with red colour
3) if the cell already full, insert new cell below the existing one.

the result will look like in sheet2


Book1.xlsx

[Richard Buttrey]

Hi,

You don't necessarily need VBA. See attached.

If however you want to achieve the same thing with VBA just get VBA to write the function to one cell and copy and paste it to all the rest.

[kvsrinivasamurthy]

One more trail. Pl see file.

[airbatucampur92]

but requirement stated to do it using VBA. can u help me???

[kvsrinivasamurthy]

Pl see attached file with macro