Combining and copying cells if a condition is met

[Closed]
Report
Posts
2
Registration date
Wednesday May 24, 2017
Status
Member
Last seen
May 26, 2017
-
Hi,

I want to create a VBA script that does the following:
Looks at values of column 5 (column E) of Sheet2 (values are Y or N). If the value is Y, I want it to combine the text in columns A and C of that same row (first A, then a space, then C) of Sheet2, and paste it in Column B of Sheet1. Then, I want it to find the value in column J of Sheet2 in the same row, and paste it in Column C of Sheet1. Is this possible? I've been struggling a lot because I don't really know excel/vba code.