Need help with a find and replace type macro. I've tried VLOOKUP but
I don't think it will provide what I'm looking for.
I have a column of numbers in Sheet A that I correspond with a row of
data in Sheet B. Sheet B has thousands of lines of data that I do not
need, I only need the several dozen numbers from the column in Sheet
A.
I've run the record function, and this is what I have so far
Sub ESTSearch()
'
' ESTSearch Macro
' Macro recorded 4/2/2010 by
'
'
Range("A2").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("EST").Select
ActiveWindow.SmallScroll ToRight:=56
Columns("BP:BP").Select
Selection.Find(What:="Q5AUVRES", After:=ActiveCell,
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows,
SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Rows("438:438").Select
Range("BE438").Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("QB").Select
Rows("2:2").Select
ActiveSheet.Paste
End Sub
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
To unsubscribe, reply using "remove me" as the subject.
