Copy Cell value(A1)sheet1 and paste to all rows of column E sheet2

Help Studio
, ,
1

Hello,
Please help me on how to Copy Cell value(A1)sheet 1 and paste to all rows of column E sheet 2.
Copy.xlsx (9.3 KB).

sheet 2 rows are dynamic.

2

@POOJA_MARUTI_BALIGIDE

  1. read cell A1 in to str using read cell activity
  2. write cell activity to write data from str to E1
  3. Auto fill range to fill the data for all rows

cheers

3

@POOJA_MARUTI_BALIGIDE

check this once

copyandwriteinanother sheet.zip (3.4 KB)

cheers

4

@Shiva_Nikhil ,

Thank you for the reply.

I want to write whole cell value to sheet 2.
image

5

@Anil_G ,
Thank you for replying.
I am able to write data to column E. but its writing all rows of column E irrespective of the actual rows. and Sheet2 rows vary from file to file.
Sequence4.xaml (12.3 KB)

6

@POOJA_MARUTI_BALIGIDE

Then you pass the output of read cell activity directly to the write cell

No need to split the value

Cheers

7

@Shiva_Nikhil ,

I have tried this, I am not splitting data. but Its writing to all the rows of column E irrespective of the actual rows in dt.
Sequence4.xaml (12.3 KB)

8

@POOJA_MARUTI_BALIGIDE

can you share your expected output

9

@Shiva_Nikhil ,

Please find the expected output. and for different files in sheet2, the number of rows will vary
Copy (1).xlsx (9.4 KB)

10

@POOJA_MARUTI_BALIGIDE

image
image1210×791 46.2 KB

Main.xaml (12.4 KB)

image
image1411×672 50.1 KB

i have created output for read range activity for reading sheet2 as dt1

cheers

11

@Shiva_Nikhil ,

Thanks alot,Its working now :grinning: I tried with couple of different files too.

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.