Creating new sheet and transferring data to new sheet

Closed
Rajesharora
Posts
2
Registration date
Thursday August 1, 2013
Status
Member
Last seen
August 2, 2013
- Aug 1, 2013 at 05:38 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Aug 5, 2013 at 11:53 AM
With due respect I would like to have some Guidance for creating a excel sheet. My sheet is

Date name in out time.

This sheet contains 746 records of 26 persons. What I need is separate sheet for each person and his data tancred to his respected sheet.

Thanks in advance.


3 replies

russp5
Posts
4
Registration date
Friday August 2, 2013
Status
Member
Last seen
August 2, 2013
1
Aug 2, 2013 at 01:15 PM
You can use a filter to separate your data by person. Using the Goto > Special > Visible cells only, you can then copy only the filtered persons records to copy into a new sheet.
0
Rajesharora
Posts
2
Registration date
Thursday August 1, 2013
Status
Member
Last seen
August 2, 2013

Aug 2, 2013 at 02:59 PM
Can a macro be written for this please
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 5, 2013 at 11:53 AM
Hi Rajesharora

To do so, one needs to know the layout.

Best done by providing file using sites like www.speedyshare.com or ge.tt.

Best regards,
Trowa
0