Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set up search box to, by default, search workbook in the extraoptions? | Excel Programming | |||
Column range to search from a source workbook and then copy/paste | Excel Programming | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
Search within range for first populated cell and copy to new workbook | Excel Programming |