balaece25
03-14-2014, 08:18 AM
Guys,
I need your help to achieve the below task in an easy way using vba macro.
Requirement details
1. Need to have a report which should list the customer purchase details for each and every day.
(Each sheet should represent one customer)
2. Input file will be given daily with all the customer details.
3. Need a macro file to collate all the input files for a month in input folder and it should update the output file with one stretch.
Lets take if the customer details were given on Feb 15, then we should have atleast 12 input date files in input folder. Our system should process all these files and put an entry for 12 dates in the impacted customer sheets in output file.
The input file will be in below format.(Separate file for each day)
Code:
Customer Id, Product Name, Recived Qty, Rejected Qty
The output file will be in the below format
(Each worksheet represents each customerId)
Each sheet contains the below strtucture
Code:
Row1: CustomerName:
From Row 2:
Date,ProductName,TotalReceivedQty,TotalRejectedQty (*ColumnName Assumptions)
Thanks in Advance.
Cheers
Bala
I need your help to achieve the below task in an easy way using vba macro.
Requirement details
1. Need to have a report which should list the customer purchase details for each and every day.
(Each sheet should represent one customer)
2. Input file will be given daily with all the customer details.
3. Need a macro file to collate all the input files for a month in input folder and it should update the output file with one stretch.
Lets take if the customer details were given on Feb 15, then we should have atleast 12 input date files in input folder. Our system should process all these files and put an entry for 12 dates in the impacted customer sheets in output file.
The input file will be in below format.(Separate file for each day)
Code:
Customer Id, Product Name, Recived Qty, Rejected Qty
The output file will be in the below format
(Each worksheet represents each customerId)
Each sheet contains the below strtucture
Code:
Row1: CustomerName:
From Row 2:
Date,ProductName,TotalReceivedQty,TotalRejectedQty (*ColumnName Assumptions)
Thanks in Advance.
Cheers
Bala