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 Contributor Last seen December 27, 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 responses

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.
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
Answer 3 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response