Copy first cell value and paste all visible cells

Help StudioX
1

Hello All,

I need to copy first cell value which is filter applied and paste it to all visible cells till last row with using studioX.

Can someone help me on this.

Regards,
Anantha

2

Hi @Anantha_Krishna

Can u explain a little bit more with screenshot or dummy workflow?

Regards,
Shaf

4

Hello Shaf,

Thanks for your reply, below is the screenshot, where i need mention Global at the C Column 1st row excluding header and paste it to last row on C column.

image

5

Hi @Anantha_Krishna

We can try using loop

  1. Read Range for C column to get count of the rows then Read cell value
  2. “IF” check to see it contains value or NULL
  3. If NULL “Write cell” with Value
  4. Loop through till count

Let me know if it helps or I can also provide the solution

Regards,
Shaf