Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unknown # cells need to be in one column - Macro
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unknown # cells need to be in one column - Macro
AP - awesome... you are much smarter than I... thanks a bunch.
Kenlyn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
Dynamic column insert (macro) | Excel Discussion (Misc queries) | |||
Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |