How to update an excel worksheet by mapping a special line in an other sheet?

[Balan_Bou]

Hi guys,

I’m new on Make and never done automations in general. The task I want to automate is following :

• In the worksheet A, some lines are created automatically when I receive an answer to a form
• In the worksheet B, some lines are created automatically when I receive a payment
• In both sheets, I’ve got a column with “email adress”
• I want certain cells in the row containing the email address “test@outlook.com” in sheet A to be copied and pasted into certain cells in the row containing the email address “test@outlook.com” in sheet B.

I started to make this scenario but I can’t achieve the desired result.. (you can see the result on last picture)….

Here are the screeshot of the content of each module… If anyone could help me, I would be very grateful,

Best

[Stoyan_Vatov]

Hey there,

I’m fairly certain you can do that in excel directly. With XLOOKUP for example, or a macro. No need to involve Make.