Automatically transfering rows from one sheet to another
Solved/Closed
madi9749
Posts
2
Registration date
Tuesday 16 September 2014
Status
Member
Last seen
26 September 2014
-
16 Sep 2014 à 02:11
madi9749 Posts 2 Registration date Tuesday 16 September 2014 Status Member Last seen 26 September 2014 - 26 Sep 2014 à 00:37
madi9749 Posts 2 Registration date Tuesday 16 September 2014 Status Member Last seen 26 September 2014 - 26 Sep 2014 à 00:37
Related:
- Automatically transfering rows from one sheet to another
- How to copy data from one excel sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Excel move data from one sheet to another - Guide
- Download automatically while roaming - Guide
- Excel hyperlink to another sheet - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
16 Sep 2014 à 11:05
16 Sep 2014 à 11:05
Hi Madi,
A bit more info would be convenient.
Which column contains the DDL's (drop down lists)?
Provide sheet names, so you don't have to alter them.
Do you know how to implement codes?
Best regards,
Trowa
A bit more info would be convenient.
Which column contains the DDL's (drop down lists)?
Provide sheet names, so you don't have to alter them.
Do you know how to implement codes?
Best regards,
Trowa
Hi Trowa,
Colum H contains the DDL...
Sheet names are "'Estate Name'" and "'Estate Name' Cancellations".
I want to duplicate these sheets for different Estate Names as we will be dealing with more than 1 Estate Name at a time.
I do know how to impletment codes so if you could help that would be fantastic. Then I can manipulate the codes depending on the estate I'm dealing with.
Thank you so much - you are saving me a whole lot of "trial-and-errors"!!
Cheers
Colum H contains the DDL...
Sheet names are "'Estate Name'" and "'Estate Name' Cancellations".
I want to duplicate these sheets for different Estate Names as we will be dealing with more than 1 Estate Name at a time.
I do know how to impletment codes so if you could help that would be fantastic. Then I can manipulate the codes depending on the estate I'm dealing with.
Thank you so much - you are saving me a whole lot of "trial-and-errors"!!
Cheers
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Sep 2014 à 10:35
23 Sep 2014 à 10:35
Ok Madi,
Here you go:
Best regards,
Trowa
Here you go:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("H:H")) Is Nothing Then Exit Sub
If Target = "Cancelled" Then Target.EntireRow.Copy Sheets("Estate Name Cancellations").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub
Best regards,
Trowa
madi9749
Posts
2
Registration date
Tuesday 16 September 2014
Status
Member
Last seen
26 September 2014
26 Sep 2014 à 00:37
26 Sep 2014 à 00:37
Thank you TrowaD - that worked perfectly!!!
