Excel search and copy help

Closed
gas demo - Jan 8, 2009 at 12:32 AM
timefor7 Posts 11 Registration date Saturday October 4, 2008 Status Member Last seen May 12, 2009 - Jan 8, 2009 at 03:24 AM
Hello All,

I have Excel 2007
I would like to search a column and if the search maches my criteria then I need it to copy the entire row
to a different tab.

For instance I would like to search for LABOR in my description column and then copy the entire LABOR row into a different sheet titled LABOR. I have never used macros or functions so I am having a difficult time trying to figure this out. Please help. Thanks.
Related:

1 response

timefor7 Posts 11 Registration date Saturday October 4, 2008 Status Member Last seen May 12, 2009
Jan 8, 2009 at 03:24 AM
hi,
try tjhisd link, you will get full explanation about how to use macros in excel:
http://office.microsoft.com/en-us/excel/HA010548371033.aspx
0