How to copy and paste data of a single row but different columns?

[raghav.bhardwaj.external]

How to copy and paste data of a single row but different columns in sheet 1 no of row is not fixed means where this data will come that is not fixed as here it is at row no.99 this can be varied
but row and columns are fixed in sheet 2 where we have to paste data (F9:K9). refer screen shot attached.
using UI Path studio Coding and which activities should i use to drag and drop in the code ?

[Anil_G (Anil Gorthi)]

@raghav.bhardwaj.external

Use read range activity and provide the range you want to read “D99:I99” and make sure to uncheck the headers checkbox

Then use write range and you can provide only the first cell value there

Hope this helps

Cheers

[raghav.bhardwaj.external]

Here D99:I99 is fixed as sample but when i will run the bot in that case this is not fixed it can be anything like D22:I22 or D73:I73
so is there anything which can make it dynamic ?

[Anil_G (Anil Gorthi)]

@raghav.bhardwaj.external

Will the data be present on on those cells?

If yes then you can try leaving it blank…so that where ever data is there the bot tried to read it…

Or you can pass variable as well…and whenever you run you can chamge the range as you need

Cheers

[Pavanraj_Shetty]

Hi @raghav.bhardwaj.external

Try this

Test.zip (10.1 KB)

Cheers,

[Mohammad_Irfan (Mo Irfan)]

@raghav.bhardwaj.external Do the following

[Muhammed_Sahil]

hi @raghav.bhardwaj.external ,

Solution1.zip (9.4 KB)

Hope this will help.

[raghav.bhardwaj.external]

Can you re send the code ? or can you share screenshot of that ?

As it is not opening showing dialog box as invalid Document so .

Can you send it.

[Muhammed_Sahil]

hi @raghav.bhardwaj.external ,

can you please open the file like this →

please open using project.json, this will not show dialog box as invalid Document

Thanks

[Muhammed_Sahil]

hi @raghav.bhardwaj.external ,

i am resending the code →
solution2.zip (9.4 KB)

please let me know if it causes the issue.

Thanks