How to move data to different sheets
Closed
pb1927
Posts
1
Registration date
Tuesday November 19, 2013
Status
Member
Last seen
November 19, 2013
-
Nov 19, 2013 at 06:26 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 10, 2013 at 10:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 10, 2013 at 10:55 AM
Related:
- How to move data to different sheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How to be offline in whatsapp when data is on - Guide
- How to reduce data usage on laptop windows 11 - Guide
- Google sheet right to left - Guide
5 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 21, 2013 at 10:41 AM
Nov 21, 2013 at 10:41 AM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Dec 3, 2013 at 12:05 PM
Dec 3, 2013 at 12:05 PM
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.
Didn't find the answer you are looking for?
Ask a question
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Dec 10, 2013 at 10:55 AM
Dec 10, 2013 at 10:55 AM
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
