Sort by column A, B and print dates range

Closed
veera1 - 19 Jun 2012 à 20:31
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 28 Jun 2012 à 18:58
Hello,
I have 3 columns
emp no: Leave type Date leave taken
12 CL 02/12/2011
12 CL 02/13/2011
12 SL 03/14/2011
13 PL 03/ 12 2011
13 PL 03/13/2011

need output as
emp no: Leave type Date leave taken leave end date
12 CL 02/12/2011 02/13/2011
12 SL 03/14/2011 03/14/2011
13 PL 03/ 12 2011 03/13/2011

Please help me out to write a macro in excel to get the desired O/P
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Jun 2012 à 18:58
On the same sheet?