Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for Search
I need a macro that will search one sheet and return a copy of the row on
another sheet using multiple search criteria... I have a spreadsheet that logs data on one sheet called "Design Review Log". That sheet has 8 columns. The headers are "Description, #, Seat Model, Type, Customer Code, Date, Job #, Open/Closed. I have another sheet called "Search" where I want to create a search feature using a macro that can search by multiple criteria. I have placed the same headers in row 2 and using row 3 to enter the criteria. For example, I may want to search for a specific Customer code and Job #. If there are any rows on "Design Review Log" that meets both criteria it will copy and paste the rows on the "Search" sheet. I want to be able to search using 1 criteria or up to all 8. If I do another search, I want it to clear the first search results and copy and paste the new results. -- -Brigette |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro search | Excel Discussion (Misc queries) | |||
Search Macro | Excel Discussion (Misc queries) | |||
Search In a Macro/VBA | Excel Discussion (Misc queries) | |||
Text Search Macro? | Excel Discussion (Misc queries) | |||
search macro | Excel Discussion (Misc queries) |