I am having a datatable with 470 columns and 69 rows
the each column name is a code and first column contains the filteration key to filter with the other datatable which is having the result of these keys.
Master DT –
Here starting from 22657 ,35975 , etc are the codes and vertically first column (RSF 1Ltr,RSF500ml) are the keys to filter the another datatable.
One code is having 69 rows to be filtered with the below dt
ere the code must be filtered with column customer code and SKU column must be filtered with the SKU column of master dt like RSF 1ltr etc… and with the filtered DT the billed quantity column must be added up and the value must be updated in master dt corresponding to the code and SKU key.
Please help me with VBA to do this by using UiPath for each loop activities it will take huge time.