Hi All,
I am looking for help to do the following (have approx. 7k rows that need to be split into line items):
Sheet 1
Emp Id Date-From Date-To Absence Reason
2470 03-Feb-2014 07-Feb-2014 Jury Duty
create the following on another sheet
Sheet 2
Emp Id Date-From Date-To Absence Reason
2470 03-Feb-2014 03-Feb-2014 Jury Duty
2470 04-Feb-2014 04-Feb-2014 Jury Duty
2470 05-Feb-2014 05-Feb-2014 Jury Duty
2470 06-Feb-2014 06-Feb-2014 Jury Duty
2470 07-Feb-2014 07-Feb-2014 Jury Duty
Many Thanks
eeidmna
Bookmarks