Selectively Copying Information to a subset

  • Thread starter Thread starter Yuke
  • Start date Start date
Y

Yuke

I'm managing documents for my company. A master list of the documents
contains in Col. A, the documents' reference number, as well as
information regarding each document in columns B-F.

I'm responsible for a subset of the master list, and I have an excel
spreadsheet with the document reference numbers I am responsible for. I
would like to selectively copy from the master list, the information in
columns B-F from the master list, but only for those documents that are
in my subset list.

How do I do this? thanks in advance :)
 
On way would be to use your list as the criteria range and then use advanced
filter to retrieve the matching information. (Data=>Filter=>Advanced
Filter) You would then copy A-F to a new location (an option of Advanced
filter).
 
Back
Top