How to get the particular cell vale in a particular column

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


Take a look here for starters:

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



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


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

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


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


try this

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


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