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 :)


--
Yuke
------------------------------------------------------------------------
Yuke's Profile: http://www.excelforum.com/member.php...o&userid=16313
View this thread: http://www.excelforum.com/showthread...hreadid=277043

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

--
Regards,
Tom Ogilvy



"Yuke" wrote in message
...

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 :)


--
Yuke
------------------------------------------------------------------------
Yuke's Profile:
http://www.excelforum.com/member.php...o&userid=16313
View this thread: http://www.excelforum.com/showthread...hreadid=277043