I have Following Master Table in Sheet1
<tbody>
Column A
Column B
Column C
Column D
Column E
Column F
Column G
Row1
Cus_Code
Inv_Date
Inv_No
Cus_Name
Value
VAT
Row2
BBE
18/07/2018
SV4525
A CO .LTD
11899
1785
Row3
BBE
20/07/2018
SV4531
A CO.LTD
16667
2500...
I have Following Master Table in Sheet1
<tbody>
Column A
Column B
Column C
Column D
Column E
Column F
Column G
Row1
Cus_Code
Inv_Date
Inv_No
Cus_Name
Value
VAT
Row2
BBE
18/07/2018
SV4525
A CO .LTD
11899
1785
Row3
BBE
20/07/2018
SV4531
A CO.LTD
16667
2500...
<tbody>
Cus_Code(Column A)
Name (Column B)
TIN (Column C)
VAT (Column D)
Rs.(Column E)
BBE
ABC Perra
104074472
SVAT001084
2550
Row1
BTE
D. KAMAL
114169161
SVAT000585
3256
Row2
DSL
L.SUNIL
114337617
103256
2456
Row3
ELS
F.SILVA
114089087
SVAT000550
11000...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.