How to move data to different sheets
Closed
pb1927
Posts
1
Registration date
Tuesday 19 November 2013
Status
Member
Last seen
19 November 2013
-
19 Nov 2013 à 18:26
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Dec 2013 à 10:55
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Dec 2013 à 10:55
Related:
- How to move data to different sheets
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- How to check t mobile data - Guide
- Google sheets download - Download - Spreadsheets
- Google sheets right to left - Guide
5 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
21 Nov 2013 à 10:41
21 Nov 2013 à 10:41
Sure pb1927, where do you get stuck?
Provide more details in your reply.
Best regards,
Trowa
Provide more details in your reply.
Best regards,
Trowa
Sorry for delay getting back to you and thank you for your reply.
Have not had to move data from one sheet to another before now. This is new to me.
I want or need several sheets but then want a master log. The data would not go to the same line on the master sheet but on the next available line and keep going down the master log
Have not had to move data from one sheet to another before now. This is new to me.
I want or need several sheets but then want a master log. The data would not go to the same line on the master sheet but on the next available line and keep going down the master log
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
3 Dec 2013 à 12:05
3 Dec 2013 à 12:05
Hi pb1927,
Not a lot of details :(.
Think about when you want data to move to the master sheet.
Best regards,
Trowa
Not a lot of details :(.
Think about when you want data to move to the master sheet.
Best regards,
Trowa
Was thinking have it move after it is entered into the cell. Might be just as easy to just do a copy and paste because it will not be on same line every time. Need it to go to first available line on mater log and then next entry go to next line etc.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Dec 2013 à 10:55
10 Dec 2013 à 10:55
Hi pb1927,
Try this:
Right-click on the sheets tab (other then the master sheet) > View Code.
Paste the following code in the big white field:
You can close the 'Microsoft Visual Basic' window.
Back to the sheet you chose. Whenever you enter a value in column I, the entire row is copied to the sheet called 'Master' at the first available row.
Modify the code to match your requirements.
Best regards,
Trowa
Try this:
Right-click on the sheets tab (other then the master sheet) > View Code.
Paste the following code in the big white field:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("I:I")) Is Nothing Then Exit Sub
Rows(Target.Row).Copy Sheets("Master").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
You can close the 'Microsoft Visual Basic' window.
Back to the sheet you chose. Whenever you enter a value in column I, the entire row is copied to the sheet called 'Master' at the first available row.
Modify the code to match your requirements.
Best regards,
Trowa
