Transfering data from one sheet to another, but not duplicating.
Closed
RR2105
Posts
2
Registration date
Friday May 31, 2013
Status
Member
Last seen
June 3, 2013
-
May 31, 2013 at 12:37 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 4, 2013 at 11:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 4, 2013 at 11:06 AM
Related:
- Transfering data from one sheet to another, but not duplicating.
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire id transfer facebook to google - Guide
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- Tmobile data check - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 1, 2013 at 06:10 PM
Jun 1, 2013 at 06:10 PM
Before moving the data, if there is a unique way of identifying that data is already there then it would be possible
RR2105
Posts
2
Registration date
Friday May 31, 2013
Status
Member
Last seen
June 3, 2013
Jun 3, 2013 at 09:35 AM
Jun 3, 2013 at 09:35 AM
I have a timestamp set up in column Q that puts a date and time in when column P changes to welldown. The timestamp does not change until the status changes in column P back to running. Then the timestamp disappears. I was hoping to use the timestamp in some way for it to recognize that the date and time had not changed and not copy it to the log sheet, but if it has changed then copy it. Any ideas on how to get that to work? Thanks
RR2105
RR2105
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 4, 2013 at 11:06 AM
Jun 4, 2013 at 11:06 AM
Hi RR2105,
Little confused.
You talk about hitting a button to activate the code, but your code is set up to run automatically (ie. Worksheet_Change).
You talk about the code reacting to the text "Text" but in the code you refer to "WELL DOWN".
I will go with your story.
Try this code:
Best regards,
Trowa
Little confused.
You talk about hitting a button to activate the code, but your code is set up to run automatically (ie. Worksheet_Change).
You talk about the code reacting to the text "Text" but in the code you refer to "WELL DOWN".
I will go with your story.
Try this code:
Sub test() Dim Target As Range Dim Exist As Boolean Dim lRow As Integer Application.ScreenUpdating = False Set Target = ActiveCell Exist = False lRow = Sheets("LOG").Range("P" & Rows.Count).End(xlUp).Row If Intersect(Target, Range("P:P")) Is Nothing Then Exit Sub For Each cell In Sheets("LOG").Range("P1:P" & lRow) If cell.Value = Target.Offset(0, 1).Value Then Exist = True Next cell If Target.Value = "Text" And Exist = False Then Range("B" & Target.Row, "BH" & Target.Row).Copy Sheets("LOG").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues End If Application.CutCopyMode = False Application.ScreenUpdating = True End Sub
Best regards,
Trowa