Selectively Copying Information to a subset
 

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

--
Yuk
-----------------------------------------------------------------------
Yuke's Profile: http://www.excelforum.com/member.php...fo&userid=1631
View this thread: http://www.excelforum.com/showthread.php?threadid=27704

Selectively Copying Information to a subset
 

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.

--
Regards,
Tom Ogilvy

"Yuke" wrote in message
...

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


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