Getting Data from 2 Excel workbook

Help StudioX
,
1

Hi All, how can I work on to get data from 2 Excel workbook based on conditioned to flow into an master excel template ?

2

Hi @Lee_Danial

Could you elaborate your requirement on
Clearly?

Regards

3

Hi Pravin, I have 2 excel files that I want to extract data and fill into a master excel sheet.
so from my in-house system, I can generate this 2 report, “Shipment Profile” & “AR Charge Code”.

Based on “Shipment Profile” report Column “P”, example “PMT BTY” column C to column W information with flow into master sheet column A to R.

Once data flow into Master Sheet, column S to column AO will be taken from report “AR Charge code”,

based on Master Sheet column B “shipment number” to flow in the data based on column “H” and fill up accordingly to master sheet column S to column AO

4

image
image1912×992 112 KB

“Shipment Profile”

5

image
image1918×957 85.1 KB

“AR Charge Code” Report

6

image
image1914×800 77.8 KB

“Master Sheet”

7

image
image1199×771 39.4 KB

Based on “AR Charge Code” column H, to flow in the data in column P into Master Sheet report

8

Hi @Lee_Danial

Seems tricky looping @Yoichi @ppr @Palaniyappan

Regards

9

Hi All,

is there any update ?

10

Hi @pravin_calvin @Yoichi is there any update on this?