Unknown # cells need to be in one column - Macro

Giganews Newsgroups
Subject: Unknown # cells need to be in one column - Macro
Posted by:  kenl…@americollect.com
Date: 26 May 2006

Somebody must be smarter than I ... that I know.

I have the following data in an excel sheet:
Columns
A              B
JK              3
BK            1
PS              2

Where Column A is the names of employees, which has an  unknown number
of  rows and column B is the # of raffles they won - the number of
raffles they win changes.  I am trying to write a macro that does this
.... put the number of raffles in column C in a row ...

C
JK
JK
JK
BK
PS
PS

Once this is done - i have a random number generator pick from this
list ....

Thanks a bunch - to the many of you smarter than I.

Excel 2003

Kenlyn T. Gretz

Replies