Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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

Answer 1 / 3
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
Answer 2 / 3
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
Answer 3 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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