Linq Query based on filteration based on multiple columns

Help Activities
, ,
1

image
image1920×1080 257 KB

Each row must be filtered in different sheet based on column names and value must be written under it.

2

@Melbin_Antu1

Please wxplain it a little more …or attach an sample input and expected output

Cheers

3

i want a linq query in which the there are 5 columns in the Above Backup Sheet (MFS,OP,Pend,BNE,Ysec) and 1 Row( SKU Group) i have an customer code that where filter the values and paste into the above columns. first we want to check the customer code with SKU Group thats why for MFS column we want go to MFS Sheet and check with the customer code and SKU Group and take the value and paste into the MFS column on Backup Sheet. like this

4

If you need filtering of excel, I would suggest you to use filter activity rather the LINQ, as it will be simple to use.

5

@Melbin_Antu1

Please provide a sample file…for giving a proper one…else please try to build using these generic instructions

Cheers

6

Ya but its take lot of time i have 470 colums and 69 rows its takes more than 1 hour thats why i asked to linq query

7

image
image1920×1080 303 KB

here is the sample MFS Sheet here we can get the values and paste on the Backupsheet under MFS column

8

Any Updates for the question Bro

9

@Melbin_Antu1

If you send the file it would be esy…with screenshots we cannot as we nees to recreate something again

Cheers