How to choose different column values at a time

[anjani_priya]

how to choose different column names at a time
for example: if we have different depts in column how to choose them all at a time

[Dinesh_Guptil]

Hi @anjani_priya
Can you give the input and the expected output.

[anjani_priya]

there are three sheets ly cy aop
from LY,CY,LOP sheets, dept and month wise the salary should be sum and convert that into crores format and should fill the input sheet
how to do that
Book1.xlsx (78.4 KB)
here how to select all depts at a time?

[anjani_priya]

how to select all depts at a time?

[sai_gupta]

@anjani_priya

dt.AsEnumerable.Where(Function(row) {"HR", "IT", "FINANCE","MANUFACTURING","finance"}.Contains(row.Field(Of String)("dept"))).CopyToDataTable

[Dinesh_Guptil]

Hi @anjani_priya
Change the sheets as shown below

Can use the below Xaml File for your requirement
It Helps you with the output sheet

Forum.zip (33.7 KB)
Cheers!

[anjani_priya]

error

[anjani_priya]

I didn’t understand the code. Can you explain with annotations in code?
and the month should be considered.
in input sheet the date is mentioned. Upto that date, the data should be sum

[Dinesh_Guptil]

Hi @anjani_priya

Can Check the below code
Forum.zip (34.2 KB)
Cheers!

[Dinesh_Guptil]

@anjani_priya

Check The below code with annotations
Forum.zip (34.6 KB)

It Helps!