airbatucampur92@gmail.com
New member
- Joined
- Jul 9, 2014
- Messages
- 11
- Reaction score
- 0
- Points
- 0
Hi all
I have two sheets; sheet1 and sheet2.
Sheet1 will be the source and sheet2 will be the result or target.
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 that i attached below
thanks.
View attachment Book1.xlsx
I have two sheets; sheet1 and sheet2.
Sheet1 will be the source and sheet2 will be the result or target.
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 that i attached below
thanks.
View attachment Book1.xlsx