Selectively Copying Information to a subset

[Yuke]

seems like i've created a mini-menu that lists my criteria fo
selectively moving around the spreadsheet. I actually wanted to creat
an entirely new spreadsheet with just the documents that I am managing

 

[Tom Ogilvy]

Select the master sheet and do Edit=>Move or copy sheet, select the copy box
in the lower right and new workbook.

Now you have all the documents in a new workbook.

in column G2 put in

=if(iserror(Match(A2,[MyDocs.xls]Sheet1!$A:$A,0)),"Delete","Keep")

then drag fill it down the column.

select this column (G) and do Data=>Filter=>Autofilter and select Delete in
the dropdown arrow in column G

Select all the rows in your data (except the header row, row 1) and do
Edit=>Delete

Then select Data=>Filter=>Autofilter to remove the autofilter. Only the
documents you are assigned should be left.

Turn on the macro recorder while you do it manually to get a start on code.
Then clearn up what you record.