Entering data on differnent sheets in WB
 

Does anyone have any suggestions for:

I have a spreadsheet with approximately 100 rows of data, however thi
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 th
value on workbook 2- cell A1. Each account number in column E workbbo
1 would be input on a different sheet on workbook two without enterin
duplicates.

Any help would be greatly appreciated

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=46830

Entering data on differnent sheets in WB
 

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