How to choose different column values at a time

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

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

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?

how to select all depts at a time?

@anjani_priya

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

Hi @anjani_priya
Change the sheets as shown below
image

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

Forum.zip (33.7 KB)
Cheers!


error

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

Hi @anjani_priya

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

@anjani_priya

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

It Helps!

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