Search and Copy from one tab to a second tab in the same workbook
 

I'm having difficult writing the macro to do a search on a certain field on
one workbook and copy the entire row of data onto a second tab any ideas?
--
MC

Search and Copy from one tab to a second tab in the same workbook
 

Show us what you have done so far

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"markcope91" wrote in message
...
I'm having difficult writing the macro to do a search on a certain field
on
one workbook and copy the entire row of data onto a second tab any ideas?
--
MC

Search and Copy from one tab to a second tab in the same workbook
 

set sht1 = sheets("Sheet1")
set sht2 = sheets("Sheet2")


set c = sht1.columns("A").find(what:="abc", _
lookin:=xlvalues,lookat:=xlwhole)
if not c is nothing then
sht1.rows(c.row).copy _
destination:=sht2.rows(5)
end if


"markcope91" wrote:

I'm having difficult writing the macro to do a search on a certain field on
one workbook and copy the entire row of data onto a second tab any ideas?
--
MC