Urgent Help....

K

kiran

Hi All,
I have 4 csv report file with the following file name as follows :-
Interspec_CH_EOD_Report.csv
CHPending.csv
Interspec_HD_EOD_Report.csv
HDPending.csv

my query is I want all HDPending.csv data to be copied in
Interspec_HD_EOD_Report.csv file at the end of the row of

Interspec_HD_EOD_Report.csv file deleting the heading row from HDPending.csv
like for CHPending.csv also to be copied to Interspec_CH_EOD_Report.csv file.
Then I want common data to be removed no data to be repeated.

TIA
 
S

Sheeloo

Open all files in Excel...

Copy and paste as you want...

Sort the data
Select data
Choose Data->Filter->Advanced Filter
Choose Copy to another location
Click on Uniqe Records only
Specify where you want the result
Click Ok
 
Top