Hi,

my source data is:Sheet2 contains:

Month IDnumber Tiltle Descript App Hours
April 2091 abc xyz IT 0
April 2091 abc xyz IT 10
APril 2091 abc xyz IT 0
April 2091 abc xyz Admin 25
April 2091 abc xyz Admin 0
April 2062 uvw jmn IT 0
my Sheet 1:
On entering the month value, The macro should populate the sheet1 with
only the distinct values. My output should appear as follows:

Month IDNumber Title App Hours

April 2091, abc IT, Admin 10,25
2062 uvw IT 0

Please suggest a macro which would help accomplish the above result,
I'm not concerned if the hours do not populate as it sums for IT and
admin separately but I need to get distinct values only in IDNumber
and Title and App

thanks in advance