Related:
- Copy entire row from one tab into another
- Saints row 2 cheats - Guide
- Incognito tab opera - Guide
- Change new tab page chrome - Guide
- Auto refresh chrome tab - Guide
- Java update tab missing - Guide
1 response
Ivan-hoe
Posts
433
Registration date
Saturday 16 February 2008
Status
Member
Last seen
17 October 2008
110
9 Sep 2008 à 02:35
9 Sep 2008 à 02:35
Hello Christian,
Please copy here the macros you used and afterwards we'll try to see what goes wrong in them.
Ivan
Please copy here the macros you used and afterwards we'll try to see what goes wrong in them.
Ivan
16 Oct 2008 à 09:45
I'm trying to do something almost exactly the same as Christian above, but I wouldn't want to delete the orginal line of data I'm copying from and I haven't begun to write a macro for it yet as I'm not very good with it. I've been looking for help for this one for some time now and haven't been able to get any. Can you help please?
Thanks!
3 Nov 2008 à 14:35
Here is my code. I am looking to search for a row in worksheet 2 corresponding to a value entered in worksheet 1. If the value matches, it will copy the rows to worksheet 1. So far I discovered that while debugging it does search right; but is unable to copy. Can you please help me?
Sub Value_Proposition_NewSearch()
'
' Value_Proposition_NewSearch Macro
'
'
Dim wksTarget As Worksheet, wksSource As Worksheet
Dim rngTarget As Range, rngSource As Range, rngID As Range
Dim iD As String
Set wksTarget = ThisWorkbook.Sheets("Menu")
Set wksSource = ThisWorkbook.Sheets("ValuePropositionData")
Set rngID = wksTarget.Range("a24")
'clear any old data on summary sheet
Set rngTarget = rngID.SpecialCells(xlCellTypeLastCell)
If rngTarget.Row > rngID.Row Then
wksTarget.Range(rngID.Offset(1), rngTarget).EntireRow.ClearContents
End If
'matching rows will get copied to summary sheet starting row 3
Set rngTarget = rngID.Offset(25)
'find matching rows on address sheet starting row 2
Set rngSource = wksSource.Range("a9")
iD = rngID.Value
Do Until (rngSource.Value = "")
If rngSource.Value = iD Then
Application.CutCopyMode = True
rngSource.EntireRow.Copy
wksTarget.Paste rngTarget
Application.CutCopyMode = False
Set rngTarget = rngTarget.Offset(1)
End If
Set rngSource = rngSource.Offset(1)
Loop
End Sub
16 Apr 2010 à 00:07