Automatically transfer data between worksheets
Closed
Murphs21
Posts
1
Registration date
Wednesday May 31, 2017
Status
Member
Last seen
May 31, 2017
-
May 31, 2017 at 10:57 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jun 2, 2017 at 10:35 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jun 2, 2017 at 10:35 PM
Related:
- Automatically transfer data between worksheets
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire transfer - Guide
- Tmobile data check - Guide
- Pc restarts automatically - Guide
- Download automatically while roaming - Guide
2 responses
take a look at this:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
All of what you have asked can be "cut and pasted" from that article, you just have to put it all into the right order based on the final product you want!
Let us know!
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
All of what you have asked can be "cut and pasted" from that article, you just have to put it all into the right order based on the final product you want!
Let us know!
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jun 2, 2017 at 10:35 PM
Jun 2, 2017 at 10:35 PM
Hello Karine,
Further to ac3mark's post, another option would be to use a Worksheet_Change event code, such as follows:-
If your "Status" column is Column D (or column 4) then, with the above code, once you enter the appropriate status, the entire row of data will be transferred to its individual sheet once you click away (or press enter or down arrow). The code will also clear the "used" data from the main (input) sheet.
I'm assuming that each status has an individual sheet named the same as the status.
To implement the code, right click on the main (input) sheet. From the menu that appears, select "view code" and in the big white field that then appears, paste the above code.
Remember to make the entry in the "Status" column the very last data entry.
I hope that this helps.
Cheerio,
vcoolio.
Further to ac3mark's post, another option would be to use a Worksheet_Change event code, such as follows:-
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Application.EnableEvents = False
If Intersect(Target, Columns(4)) Is Nothing Then Exit Sub
Target.EntireRow.Copy Sheets(Target.Value).Range("A" & Rows.Count).End(3)(2)
Target.EntireRow.Delete
Application.EnableEvents = True
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub
If your "Status" column is Column D (or column 4) then, with the above code, once you enter the appropriate status, the entire row of data will be transferred to its individual sheet once you click away (or press enter or down arrow). The code will also clear the "used" data from the main (input) sheet.
I'm assuming that each status has an individual sheet named the same as the status.
To implement the code, right click on the main (input) sheet. From the menu that appears, select "view code" and in the big white field that then appears, paste the above code.
Remember to make the entry in the "Status" column the very last data entry.
I hope that this helps.
Cheerio,
vcoolio.
