excel 2003
Help
Advanced Filter - Unique records

"STEVEB" wrote:


Does anyone have any suggestions for:

I have a spreadsheet with approximately 100 rows of data, however this
varies each week. Column E is various account numbers WITH DUPLICATES.


I would like:
A Macro that would look at column E on workbook 1 and ener enter the
value on workbook 2- cell A1. Each account number in column E workbbok
1 would be input on a different sheet on workbook two without entering
duplicates.

Any help would be greatly appreciated!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=468306