Entering Data

[STEVEB]

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!

[zzzzzzzzz]

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

[STEVEB]

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 help