View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bulldawgfan12000@yahoo.com is offline
external usenet poster
 
Posts: 4
Default 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.