Automatically transfer data between worksheets
Closed
Murphs21
Posts
1
Registration date
Wednesday 31 May 2017
Status
Member
Last seen
31 May 2017
-
31 May 2017 à 10:57
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 2 Jun 2017 à 22:35
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 2 Jun 2017 à 22:35
Related:
- Transfer data from one excel worksheet to another automatically
- Copy data from one Excel sheet to another: automatically - Guide
- Excel move data from one sheet to another - Guide
- How to copy data from one excel sheet to another - Guide
- Export data from excel - Guide
- Free fire transfer - 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
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
2 Jun 2017 à 22:35
2 Jun 2017 à 22:35
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.
