Luking for a VBA code to import datas of two csv files into excel sheet1 and sheet2 based on some conditions

[faizumarali]

I am attaching the files for your reference.

MASTER FILE

http://www.box.net/shared/dat9pgal4o


PAF FILE

http://www.box.net/shared/itz4dbg48h


PSI FILE

http://www.box.net/shared/cdj0szqhj3



My datas are in the path "C:\Temp"


I have three files named 0001.PAF, 0002.PSI & Master File.xls


The first two files (name of the file will be different each time) are basically CSV files but their extention changed from CSV to PAF & PSI respectively.


0001.PAF has the fields from column A to Column J.
The required fields in the context are Column B,E,F,G,H


0002.PAF has the fields from Column A to Column J (in which column E,F,G,H,I blank)
The required fields in the context are Column B & C



POINTS:

1. PAF Files contains the salary details of the employee Column G+H is the total salary of the employee
2. PSI file contains the name of the employee
3. There is 14 digit no in these two PAF & PSI files which is the employee id and is required to identify the correct employee and correct salary by using VLOOKUP function



My task is to import the data contained in two files that is 0001.PAF & 0002.PSI (basically CSV file only the extension different) into sheet1 and sheet2 of Master File.xls based on the follwoing conditions

1. The data should be imported after using the VLOOKUP function, so as to ensure the accuracy of the data
2. Employee Name should be sorted in the alphabetical order
3. Salary amount should be the total salary ie G+H from PAF FILE
4. Total Salary should be splitted into currency denomination of 500,100,50,20,10,5,1
5. The data should have Header (The co name in the header is there is the last name in PSI file)
6. The data should have Footer (The data always: SALARY PAYOUT by: XYZ CO LTD
7. The alignment and format of the data should be as per the Master File



Kindly note my Output file Master File.xls for your refenece



Thank you all for going through my post. Awaiting for a solution. Thank you.

 

[faizumarali]

Can somebody help on this post. Thank you.

 

[faizumarali]

First time ever, i didn't get a reply from the forum, a bit disappointed.