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.
|