vba code for desired out put

[yogeshp]

Hello all of u all,
New to this forum ..
my input files
1)1.zip which
2) DTC fdr wise which contains name of persons.
I want to develop VBA code to get desired output in Excell file having..
columns with names as
1. SR NO ( total sr no as in zip file should come which changes everytime as per file)
2. DTC CODE ( 7 digit nos starting from 0655 or 6551)
3. consumer name
4. Adress
5.Tarrif
6. Bill Amt
7.Due Date
8.Op arr
9.Op Int
10. Receipt Date
11.Receipt Amt
12. SD arrears
13. Payable
14. Staff / person name by vlookup in input sheet DTC CODE value and lookup array in DTC Fdr wise input file
Thanks in advance

 

[Deepak]

yogeshp

I have deleted the zip file as it contain personal information like as mobile number and address.

You are not allowed to share one's privacy data without the consent.

You may re upload the file after removing such things or converting them to a dummy data!

 

[yogeshp]

ok understood rules.. no problem