A
AS
Hi,
I have following excel information and trying to copy information with
heading to rows to new worksheet with worksheet name to be display with
employee id including additional column has information to count the number
of record in that worksheet by employee id.
Input file:
Employee ID Employee Name Amount
9100 John 15.00
9100 John 25.99
9200 Marc 14.99
Output File:
Employee ID Employee Name Amount Count
9100 John 15.00 2
9100 John 25.99 2
sheet(9100)
Employee ID Employee Name Amount Count
9200 Marc 14.99 1
Your help will be highly appreciated.
Thanks
I have following excel information and trying to copy information with
heading to rows to new worksheet with worksheet name to be display with
employee id including additional column has information to count the number
of record in that worksheet by employee id.
Input file:
Employee ID Employee Name Amount
9100 John 15.00
9100 John 25.99
9200 Marc 14.99
Output File:
Employee ID Employee Name Amount Count
9100 John 15.00 2
9100 John 25.99 2
sheet(9100)
Employee ID Employee Name Amount Count
9200 Marc 14.99 1
Your help will be highly appreciated.
Thanks