Automate Finding Values/Copy to Different Sheet
 

Hi.

With work, I create a lot of excel documents made from others. For
example, going down a list of users (column A) and finding the ones
with certain values in Column B. Then copying information from those
rows to a different sheet. It seems like it would be easy to be able
to input into a program what value to look for in column b. Copy the
values from that row (column c & d) to a different sheet named (x or
whatever).

If anybody knows of something like this out there already (seems
likely) could you please refer me to it. Otherwise, I am very willing
to write something up myself, but didnt want to reinvent the wheel.

Thanks.

Automate Finding Values/Copy to Different Sheet
 

Maybe Ron de Bruin's EasyFind will work for you:
http://www.rondebruin.nl/easyfilter.htm

wrote:

Hi.

With work, I create a lot of excel documents made from others. For
example, going down a list of users (column A) and finding the ones
with certain values in Column B. Then copying information from those
rows to a different sheet. It seems like it would be easy to be able
to input into a program what value to look for in column b. Copy the
values from that row (column c & d) to a different sheet named (x or
whatever).

If anybody knows of something like this out there already (seems
likely) could you please refer me to it. Otherwise, I am very willing
to write something up myself, but didnt want to reinvent the wheel.

Thanks.

--

Dave Peterson