Pasting one cell to several rows

[Gulben]

I am trying to automate the following scenario in Make.com:

1. Get one specific data by using an API key.
2. Put that value in an Excel cell (and when that cell changes, another cell changes accordingly by a formula in Excel, and gives me the value in cell 6F). So far, everything works.
3. Take that value (6F) and paste it into another Excel sheet’s rows. I want to take one value (number) and put the exact same value in more than one row (D4-D27). However, I can only find how to put it in one row (using the update one row module).

Can someone help me with how to do that? Thank you so much.

[Msquare_Automation]

Hey @Gulben

You are looking for a bulk update. However, microsoft excel does not have this action.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

[Gulben]

Thank you. Do you have any idea how to approach it ?