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=46795

sort the sheet with dups by account #
do a for loop

for i =2 to activesheet.usedrange.rows.count
if activecell.value = activecell.offset(1,0).value Then' acct # same
activecell.offset(1,0).select
else
copy your info to the 1st sheet
end if
next

if you want to copy 1 value for the 1st of the duplicates use a boolean
value and set it to false for each actcell.offset and to true when
actcell=act.off(1,0) and then use that value

"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=467953

Hi

I was unable to get the code to copy any data to the other worksheet.
Do you have any more suggestions?

Thanks for your hel

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