Automatically transfering rows from one sheet to another
Solved/Closed
madi9749
madi9749
- Posts
- 2
- Registration date
- Tuesday September 16, 2014
- Status
- Member
- Last seen
- September 26, 2014
madi9749
- Posts
- 2
- Registration date
- Tuesday September 16, 2014
- Status
- Member
- Last seen
- September 26, 2014
Related:
- Automatically transfering rows from one sheet to another
- Automatically transfer data from one sheet to another in excel - Guide
- How to automatically transfer data from one sheet to another in excel - Guide
- Automatically transfer data from one sheet to another ✓ - Forum - Excel
- Automatically transfer data from one sheet to another ✓ - Forum - Excel
- Excel automatically move row to another sheet based on date ✓ - Forum - Excel
3 replies
TrowaD
Sep 16, 2014 at 11:05 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Sep 16, 2014 at 11:05 AM
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
Sep 23, 2014 at 10:35 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Sep 23, 2014 at 10:35 AM
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
Sep 26, 2014 at 12:37 AM
- Posts
- 2
- Registration date
- Tuesday September 16, 2014
- Status
- Member
- Last seen
- September 26, 2014
Sep 26, 2014 at 12:37 AM
Thank you TrowaD - that worked perfectly!!!