Creating new sheet and transferring data to new sheet
Closed
Rajesharora
TrowaD
- Posts
- 2
- Registration date
- Thursday August 1, 2013
- Status
- Member
- Last seen
- August 2, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Creating new sheet and transferring data to new sheet
- Automatically transfer data from one sheet to another in excel - Guide
- Macro to create new sheet and copy data - Forum - Excel
- Excel transfer data from one sheet to another ✓ - Forum - Excel
- Macro to Create New Workbook and Copy Data at Each Change of X - Forum - Excel
- How to automatically transfer data between sheets in Excel - Guide
3 replies
russp5
Aug 2, 2013 at 01:15 PM
- Posts
- 4
- Registration date
- Friday August 2, 2013
- Status
- Member
- Last seen
- August 2, 2013
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.
Rajesharora
Aug 2, 2013 at 02:59 PM
- 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
TrowaD
Aug 5, 2013 at 11:53 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
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