How to get the particular cell vale in a particular column

[anjani_priya]

how to get the particular cell vale in a particular column and paste that in the another sheet dynamically

[Steven_McKeering]

Hi

Take a look here for starters:

All about Datatable - UiPath - News / Tutorials - UiPath Community Forum

Cheers

Steve

[sasi_poosarla (sasi p)]

@anjani_priya
dt_build is the table where data reads
dt_filter is the table where you need to write back that column

dt_filter=dt_Build.AsEnumerable.Select(function(x) dt_filter.Clone.LoadDataRow({x(ColumnName).tostring},false)).copytodatatable

Finally using write range activity pass the dt_filter

Cheers!!

[ninadv99 (ninad)]

@anjani_priya using ReadCell and Write cell activity in Excel Scope.

[anjani_priya]

the sum value is in edge of the row that value should be places in

first box like wise every sheet total value column should be in every box

[sasi_poosarla (sasi p)]

@anjani_priya

dt_Build.Rows(dt_Build.Rows.Count - 1)(0)

with this you will get the last row in that specific column
then you can write that to another sheet

[sai_gupta]

@anjani_priya

try this

Sheets("Sheet2").Range("A1").Value = Sheets("Sheet1").Range("A1").Value

cheers…!